package com.panasonic.cn.cmsc;

import java.io.*;
import java.lang.*;
import java.util.*;
import java.math.*;
import java.sql.SQLException;
import com.fujitsu.fks.jaaf.core.*;

public class SQLMM0299{
	private Hashtable paramsString     = new Hashtable();
	private Hashtable paramsBigDecimal = new Hashtable();
	private Hashtable paramsFree       = new Hashtable();
	private String lastSql_ = null;

	private String getString(String name){
		if(name==null) return "";
		String returnStr = (String)paramsString.get(name);
		if(returnStr==null) return "";
		return "'"+FrameworkCommon.stringReplaceSQuote(returnStr)+"'";
	}

	private String getBigDecimal(String name){
		if(name==null) return "";
		BigDecimal returnStr = (BigDecimal)paramsBigDecimal.get(name);
		if(returnStr==null) return "";
		return returnStr.toString();
	}

	private String getFree(String name){
		if(name==null) return "";
		String returnStr = (String)paramsFree.get(name);
		if(returnStr==null) return "";
		return returnStr;
	}

	public String getLastSql(){
		return lastSql_;
	}

	public int INSERT_M0201(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("            INSERT INTO");
		sql.append("	    M02");
		sql.append("	    (");
		sql.append("	    ITM_NO,");
		sql.append("	    ODR_DVSN_CD,");
		sql.append("	    APL_BDT,");
		sql.append("	    APL_EDT,");
		sql.append("	    GNR_ADM_NO,");
		sql.append("	    TMP_AC_TYP,");
		sql.append("	    SCSN_ITM_NO,");
		sql.append("	    QTY_NSUM_TYP,");
		sql.append("	    CSLD_ITM_NO,");
		sql.append("	    CTRL_DVSN_CD,");
		sql.append("	    MFCC_CD,");
		sql.append("	    PRNT_DVSN_CD,");
		sql.append("	    DSP_SPCF_CTNT,");
		sql.append("	    IBO_CAT_CD,");
		sql.append("	    FMCC_DPT_NM,");
		sql.append("	    FMCC_CHRG_NM,");
		sql.append("	    PRV_ITM_NO,");
		sql.append("	    CLR_CD,");
		sql.append("	    BRND_CD,");
		sql.append("	    HS_CD,");
		sql.append("	    ACC_CAT_CD,");
		sql.append("	    ITM_NM_ENG,");
		sql.append("	    SLS_QTY_UN_CD,");
		sql.append("	    SLC_PRMT_ITM_TYP,");
		sql.append("	    KIT_TYP,");
		sql.append("	    GFT_TYP,");
		sql.append("	    FOC_TYP,");
		sql.append("	    MIN_ODR_QTY,");
		sql.append("	    STD_PKG_SZ,");
		sql.append("	    STD_PKG_WDTH,");
		sql.append("	    STD_PKG_HI,");
		sql.append("	    STD_PKG_WGT,");
		sql.append("	    TMP_PRIZ_TYP,");
		sql.append("	    STD_UP,");
		sql.append("	    ITM_NM_CN,");
		sql.append("	    SLS_ROUT_TYP,");
		sql.append("	    RGS_DTTM,");
		sql.append("	    RGS_CHRG_CD,");
		sql.append("	    RGS_PGID,");
		sql.append("	    UPD_DTTM,");
		sql.append("	    UPD_CHRG_CD,");
		sql.append("	    UPD_PGID,");
		sql.append("	    FM_TYP");
		sql.append("	    )");
		sql.append("	    VALUES");
		sql.append("	    (");
		sql.append("	    "+getString("ITM_NO")+",");
		sql.append("	    "+getString("ODR_DVSN_CD")+",");
		sql.append("	    "+getString("APL_BDT")+",");
		sql.append("	    "+getString("APL_EDT")+",");
		sql.append("	    "+getString("GNR_ADM_NO")+",");
		sql.append("	    "+getString("TMP_AC_TYP")+",");
		sql.append("	    "+getString("SCSN_ITM_NO")+",");
		sql.append("	    "+getString("QTY_NSUM_TYP")+",");
		sql.append("	    "+getString("CSLD_ITM_NO")+",");
		sql.append("	    "+getString("CTRL_DVSN_CD")+",");
		sql.append("	    "+getString("MFCC_CD")+",");
		sql.append("	    "+getString("PRNT_DVSN_CD")+",");
		sql.append("	    "+getString("DSP_SPCF_CTNT")+",");
		sql.append("	    "+getString("IBO_CAT_CD")+",");
		sql.append("	    "+getString("FMCC_DPT_NM")+",");
		sql.append("	    "+getString("FMCC_CHRG_NM")+",");
		sql.append("	    "+getString("PRV_ITM_NO")+",");
		sql.append("	    "+getString("CLR_CD")+",");
		sql.append("	    "+getString("BRND_CD")+",");
		sql.append("	    "+getString("HS_CD")+",");
		sql.append("	    "+getString("ACC_CAT_CD")+",");
		sql.append("	    "+getString("ITM_NM_ENG")+",");
		sql.append("	    "+getString("SLS_QTY_UN_CD")+",");
		sql.append("	    "+getString("SLC_PRMT_ITM_TYP")+",");
		sql.append("	    "+getString("KIT_TYP")+",");
		sql.append("	    "+getString("GFT_TYP")+",");
		sql.append("	    "+getString("FOC_TYP")+",");
		sql.append("	    "+getBigDecimal("MIN_ODR_QTY")+",");
		sql.append("	    "+getBigDecimal("STD_PKG_SZ")+",");
		sql.append("	    "+getBigDecimal("STD_PKG_WDTH")+",");
		sql.append("	    "+getBigDecimal("STD_PKG_HI")+",");
		sql.append("	    "+getBigDecimal("STD_PKG_WGT")+",");
		sql.append("	    "+getString("TMP_PRIZ_TYP")+",");
		sql.append("	    "+getBigDecimal("STD_UP")+",");
		sql.append("	    "+getString("ITM_NM_CN")+",");
		sql.append("	    "+getString("SLS_ROUT_TYP")+",");
		sql.append("	    TO_DATE("+getString("RGS_DTTM")+",'YYYYMMDD HH24:MI:SS'),");
		sql.append("	    "+getString("RGS_CHRG_CD")+",");
		sql.append("	    "+getString("RGS_PGID")+",");
		sql.append("	    TO_DATE("+getString("UPD_DTTM")+",'YYYYMMDD HH24:MI:SS'),");
		sql.append("	    "+getString("UPD_CHRG_CD")+",");
		sql.append("	    "+getString("UPD_PGID")+",");
		sql.append("	    "+getString("FM_TYP")+"");
		sql.append("	    )");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int UPDATE_M0202(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("	    UPDATE");
		sql.append("	    M02");
		sql.append("	    SET");
		sql.append("	    ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+",");
		sql.append("	    ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+",");
		sql.append("	    APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+",");
		sql.append("	    APL_EDT "+((getString("APL_EDT").equals(""))?" is null ":"=")+getString("APL_EDT")+",");
		sql.append("	    GNR_ADM_NO "+((getString("GNR_ADM_NO").equals(""))?" is null ":"=")+getString("GNR_ADM_NO")+",");
		sql.append("	    TMP_AC_TYP "+((getString("TMP_AC_TYP").equals(""))?" is null ":"=")+getString("TMP_AC_TYP")+",");
		sql.append("	    SCSN_ITM_NO "+((getString("SCSN_ITM_NO").equals(""))?" is null ":"=")+getString("SCSN_ITM_NO")+",");
		sql.append("	    QTY_NSUM_TYP "+((getString("QTY_NSUM_TYP").equals(""))?" is null ":"=")+getString("QTY_NSUM_TYP")+",");
		sql.append("	    CSLD_ITM_NO "+((getString("CSLD_ITM_NO").equals(""))?" is null ":"=")+getString("CSLD_ITM_NO")+",");
		sql.append("	    CTRL_DVSN_CD "+((getString("CTRL_DVSN_CD").equals(""))?" is null ":"=")+getString("CTRL_DVSN_CD")+",");
		sql.append("	    MFCC_CD "+((getString("MFCC_CD").equals(""))?" is null ":"=")+getString("MFCC_CD")+",");
		sql.append("	    PRNT_DVSN_CD "+((getString("PRNT_DVSN_CD").equals(""))?" is null ":"=")+getString("PRNT_DVSN_CD")+",");
		sql.append("	    DSP_SPCF_CTNT "+((getString("DSP_SPCF_CTNT").equals(""))?" is null ":"=")+getString("DSP_SPCF_CTNT")+",");
		sql.append("	    IBO_CAT_CD "+((getString("IBO_CAT_CD").equals(""))?" is null ":"=")+getString("IBO_CAT_CD")+",");
		sql.append("	    FMCC_DPT_NM "+((getString("FMCC_DPT_NM").equals(""))?" is null ":"=")+getString("FMCC_DPT_NM")+",");
		sql.append("	    FMCC_CHRG_NM "+((getString("FMCC_CHRG_NM").equals(""))?" is null ":"=")+getString("FMCC_CHRG_NM")+",");
		sql.append("	    PRV_ITM_NO "+((getString("PRV_ITM_NO").equals(""))?" is null ":"=")+getString("PRV_ITM_NO")+",");
		sql.append("	    CLR_CD "+((getString("CLR_CD").equals(""))?" is null ":"=")+getString("CLR_CD")+",");
		sql.append("	    BRND_CD "+((getString("BRND_CD").equals(""))?" is null ":"=")+getString("BRND_CD")+",");
		sql.append("	    HS_CD "+((getString("HS_CD").equals(""))?" is null ":"=")+getString("HS_CD")+",");
		sql.append("	    ACC_CAT_CD "+((getString("ACC_CAT_CD").equals(""))?" is null ":"=")+getString("ACC_CAT_CD")+",");
		sql.append("	    ITM_NM_ENG "+((getString("ITM_NM_ENG").equals(""))?" is null ":"=")+getString("ITM_NM_ENG")+",");
		sql.append("	    SLS_QTY_UN_CD "+((getString("SLS_QTY_UN_CD").equals(""))?" is null ":"=")+getString("SLS_QTY_UN_CD")+",");
		sql.append("	    SLC_PRMT_ITM_TYP "+((getString("SLC_PRMT_ITM_TYP").equals(""))?" is null ":"=")+getString("SLC_PRMT_ITM_TYP")+",");
		sql.append("	    KIT_TYP "+((getString("KIT_TYP").equals(""))?" is null ":"=")+getString("KIT_TYP")+",");
		sql.append("	    GFT_TYP "+((getString("GFT_TYP").equals(""))?" is null ":"=")+getString("GFT_TYP")+",");
		sql.append("	    FOC_TYP "+((getString("FOC_TYP").equals(""))?" is null ":"=")+getString("FOC_TYP")+",");
		sql.append("	    MIN_ODR_QTY "+((getBigDecimal("MIN_ODR_QTY").equals(""))?" is null ":"=")+getBigDecimal("MIN_ODR_QTY")+",");
		sql.append("	    STD_PKG_SZ "+((getBigDecimal("STD_PKG_SZ").equals(""))?" is null ":"=")+getBigDecimal("STD_PKG_SZ")+",");
		sql.append("	    STD_PKG_WDTH "+((getBigDecimal("STD_PKG_WDTH").equals(""))?" is null ":"=")+getBigDecimal("STD_PKG_WDTH")+",");
		sql.append("	    STD_PKG_HI "+((getBigDecimal("STD_PKG_HI").equals(""))?" is null ":"=")+getBigDecimal("STD_PKG_HI")+",");
		sql.append("	    STD_PKG_WGT "+((getBigDecimal("STD_PKG_WGT").equals(""))?" is null ":"=")+getBigDecimal("STD_PKG_WGT")+",");
		sql.append("	    TMP_PRIZ_TYP "+((getString("TMP_PRIZ_TYP").equals(""))?" is null ":"=")+getString("TMP_PRIZ_TYP")+",");
		sql.append("	    STD_UP "+((getBigDecimal("STD_UP").equals(""))?" is null ":"=")+getBigDecimal("STD_UP")+",");
		sql.append("	    ITM_NM_CN "+((getString("ITM_NM_CN").equals(""))?" is null ":"=")+getString("ITM_NM_CN")+",");
		sql.append("	    SLS_ROUT_TYP "+((getString("SLS_ROUT_TYP").equals(""))?" is null ":"=")+getString("SLS_ROUT_TYP")+",");
		sql.append("	    UPD_DTTM = TO_DATE("+getString("UPD_DTTM")+",'YYYYMMDD HH24:MI:SS'),");
		sql.append("	    UPD_CHRG_CD "+((getString("UPD_CHRG_CD").equals(""))?" is null ":"=")+getString("UPD_CHRG_CD")+",");
		sql.append("	    UPD_PGID "+((getString("UPD_PGID").equals(""))?" is null ":"=")+getString("UPD_PGID")+",");
		sql.append("	    FM_TYP "+((getString("FM_TYP").equals(""))?" is null ":"=")+getString("FM_TYP")+"");
		sql.append("	    WHERE  ");
		sql.append("	    ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"	     ");
		sql.append("	    AND  ");
		sql.append("	    ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+"");
		sql.append("	    AND");
		sql.append("	    APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int UPDATE_M0203(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		UPDATE");
		sql.append("		M02");
		sql.append("		SET");
		sql.append("		APL_EDT "+((getString("TEMP_APL").equals(""))?" is null ":"=")+getString("TEMP_APL")+",");
		sql.append("		FM_TYP "+((getString("FM").equals(""))?" is null ":"=")+getString("FM")+"");
		sql.append("		WHERE  ");
		sql.append("		ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"	");
		sql.append("		AND  ");
		sql.append("		ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+"");
		sql.append("		AND");
		sql.append("		APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int UPDATE_M0204(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		  UPDATE");
		sql.append("		  M02");
		sql.append("		  SET");
		sql.append("		  APL_BDT "+((getString("TEMP_APL").equals(""))?" is null ":"=")+getString("TEMP_APL")+",");
		sql.append("		  FM_TYP "+((getString("FM").equals(""))?" is null ":"=")+getString("FM")+"");
		sql.append("		  WHERE  ");
		sql.append("		  ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"	     ");
		sql.append("		  AND  ");
		sql.append("		  ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+"");
		sql.append("		  AND");
		sql.append("		  APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int UPDATE_M0205(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		UPDATE");
		sql.append("		M02 ");
		sql.append("		SET");
		sql.append("		FM_TYP "+((getString("FM").equals(""))?" is null ":"=")+getString("FM")+",");
		sql.append("		APL_EDT "+((getString("TEMPDATE").equals(""))?" is null ":"=")+getString("TEMPDATE")+"");
		sql.append("		WHERE  ");
		sql.append("		ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"	     ");
		sql.append("		AND  ");
		sql.append("		ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+"");
		sql.append("		AND");
		sql.append("		APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int UPDATE_M0206(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		UPDATE");
		sql.append("		M02");
		sql.append("		SET");
		sql.append("		FM_TYP "+((getString("FM").equals(""))?" is null ":"=")+getString("FM")+"");
		sql.append("		WHERE");
		sql.append("		ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"	     ");
		sql.append("		AND  ");
		sql.append("		ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+"");
		sql.append("		AND");
		sql.append("		APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public SelectResultRset SELECT_M0207(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		    SELECT");
		sql.append("		    ITM_NO,");
		sql.append("		    ODR_DVSN_CD,");
		sql.append("		    APL_BDT,");
		sql.append("		    APL_EDT,");
		sql.append("		    GNR_ADM_NO,");
		sql.append("		    TMP_AC_TYP,");
		sql.append("		    SCSN_ITM_NO,");
		sql.append("		    QTY_NSUM_TYP,");
		sql.append("		    CSLD_ITM_NO,");
		sql.append("		    CTRL_DVSN_CD,");
		sql.append("		    MFCC_CD,");
		sql.append("		    PRNT_DVSN_CD,");
		sql.append("		    DSP_SPCF_CTNT,");
		sql.append("		    IBO_CAT_CD,");
		sql.append("		    FMCC_DPT_NM,");
		sql.append("		    FMCC_CHRG_NM,");
		sql.append("		    PRV_ITM_NO,");
		sql.append("		    CLR_CD,");
		sql.append("		    BRND_CD,");
		sql.append("		    HS_CD,");
		sql.append("		    ACC_CAT_CD,");
		sql.append("		    ITM_NM_ENG,");
		sql.append("		    SLS_QTY_UN_CD,");
		sql.append("		    SLC_PRMT_ITM_TYP,");
		sql.append("		    KIT_TYP,");
		sql.append("		    GFT_TYP,");
		sql.append("		    FOC_TYP,");
		sql.append("		    MIN_ODR_QTY,");
		sql.append("		    STD_PKG_SZ,");
		sql.append("		    STD_PKG_WDTH,");
		sql.append("		    STD_PKG_HI,");
		sql.append("		    STD_PKG_WGT,");
		sql.append("		    TMP_PRIZ_TYP,");
		sql.append("		    STD_UP,");
		sql.append("		    ITM_NM_CN,");
		sql.append("		    SLS_ROUT_TYP,");
		sql.append("		    RGS_DTTM,");
		sql.append("		    RGS_CHRG_CD,");
		sql.append("		    RGS_PGID,");
		sql.append("		    UPD_DTTM,");
		sql.append("		    UPD_CHRG_CD,");
		sql.append("		    UPD_PGID,");
		sql.append("		    FM_TYP");
		sql.append("		    FROM");
		sql.append("		    M02");
		sql.append("		    WHERE");
		sql.append("		    ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"	     ");
		sql.append("		    AND  ");
		sql.append("		    ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+"");
		sql.append("		    AND");
		sql.append("		    APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_M0208(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		    SELECT");
		sql.append("		    ITM_NO,");
		sql.append("		    ODR_DVSN_CD,");
		sql.append("		    APL_BDT,");
		sql.append("		    APL_EDT,");
		sql.append("		    GNR_ADM_NO,");
		sql.append("		    TMP_AC_TYP,");
		sql.append("		    SCSN_ITM_NO,");
		sql.append("		    QTY_NSUM_TYP,");
		sql.append("		    CSLD_ITM_NO,");
		sql.append("		    CTRL_DVSN_CD,");
		sql.append("		    MFCC_CD,");
		sql.append("		    PRNT_DVSN_CD,");
		sql.append("		    DSP_SPCF_CTNT,");
		sql.append("		    IBO_CAT_CD,");
		sql.append("		    FMCC_DPT_NM,");
		sql.append("		    FMCC_CHRG_NM,");
		sql.append("		    PRV_ITM_NO,");
		sql.append("		    CLR_CD,");
		sql.append("		    BRND_CD,");
		sql.append("		    HS_CD,");
		sql.append("		    ACC_CAT_CD,");
		sql.append("		    ITM_NM_ENG,");
		sql.append("		    SLS_QTY_UN_CD,");
		sql.append("		    SLC_PRMT_ITM_TYP,");
		sql.append("		    KIT_TYP,");
		sql.append("		    GFT_TYP,");
		sql.append("		    FOC_TYP,");
		sql.append("		    MIN_ODR_QTY,");
		sql.append("		    STD_PKG_SZ,");
		sql.append("		    STD_PKG_WDTH,");
		sql.append("		    STD_PKG_HI,");
		sql.append("		    STD_PKG_WGT,");
		sql.append("		    TMP_PRIZ_TYP,");
		sql.append("		    STD_UP,");
		sql.append("		    ITM_NM_CN,");
		sql.append("		    SLS_ROUT_TYP,");
		sql.append("		    RGS_DTTM,");
		sql.append("		    RGS_CHRG_CD,");
		sql.append("		    RGS_PGID,");
		sql.append("		    UPD_DTTM,");
		sql.append("		    UPD_CHRG_CD,");
		sql.append("		    UPD_PGID,");
		sql.append("		    FM_TYP");
		sql.append("		    FROM");
		sql.append("		    M02");
		sql.append("		    WHERE");
		sql.append("		    ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"	     ");
		sql.append("		    AND  ");
		sql.append("		    ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+"");
		sql.append("		    AND  ");
		sql.append("		    FM_TYP "+((getString("FM9").equals(""))?" is not null ":"!=")+getString("FM9")+"");
		sql.append("		    AND ");
		sql.append("		    FM_TYP "+((getString("FM6").equals(""))?" is not null ":"!=")+getString("FM6")+"");
		sql.append("		    ORDER BY ");
		sql.append("		    APL_BDT  DESC");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_M0209(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		    SELECT");
		sql.append("		    ITM_NO,");
		sql.append("		    ODR_DVSN_CD,");
		sql.append("		    APL_BDT,");
		sql.append("		    APL_EDT,");
		sql.append("		    GNR_ADM_NO,");
		sql.append("		    TMP_AC_TYP,");
		sql.append("		    SCSN_ITM_NO,");
		sql.append("		    QTY_NSUM_TYP,");
		sql.append("		    CSLD_ITM_NO,");
		sql.append("		    CTRL_DVSN_CD,");
		sql.append("		    MFCC_CD,");
		sql.append("		    PRNT_DVSN_CD,");
		sql.append("		    DSP_SPCF_CTNT,");
		sql.append("		    IBO_CAT_CD,");
		sql.append("		    FMCC_DPT_NM,");
		sql.append("		    FMCC_CHRG_NM,");
		sql.append("		    PRV_ITM_NO,");
		sql.append("		    CLR_CD,");
		sql.append("		    BRND_CD,");
		sql.append("		    HS_CD,");
		sql.append("		    ACC_CAT_CD,");
		sql.append("		    ITM_NM_ENG,");
		sql.append("		    SLS_QTY_UN_CD,");
		sql.append("		    SLC_PRMT_ITM_TYP,");
		sql.append("		    KIT_TYP,");
		sql.append("		    GFT_TYP,");
		sql.append("		    FOC_TYP,");
		sql.append("		    MIN_ODR_QTY,");
		sql.append("		    STD_PKG_SZ,");
		sql.append("		    STD_PKG_WDTH,");
		sql.append("		    STD_PKG_HI,");
		sql.append("		    STD_PKG_WGT,");
		sql.append("		    TMP_PRIZ_TYP,");
		sql.append("		    STD_UP,");
		sql.append("		    ITM_NM_CN,");
		sql.append("		    SLS_ROUT_TYP,");
		sql.append("		    RGS_DTTM,");
		sql.append("		    RGS_CHRG_CD,");
		sql.append("		    RGS_PGID,");
		sql.append("		    UPD_DTTM,");
		sql.append("		    UPD_CHRG_CD,");
		sql.append("		    UPD_PGID,");
		sql.append("		    FM_TYP");
		sql.append("		    FROM");
		sql.append("		    M02");
		sql.append("		    WHERE");
		sql.append("		    ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"	     ");
		sql.append("		    AND  ");
		sql.append("		    ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+"");
		sql.append("		    AND");
		sql.append("		    APL_EDT "+((getString("DATE9999").equals(""))?" is null ":"=")+getString("DATE9999")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_M0211(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		    SELECT");
		sql.append("		    ITM_NO,");
		sql.append("		    ODR_DVSN_CD,");
		sql.append("		    APL_BDT,");
		sql.append("		    APL_EDT,");
		sql.append("		    GNR_ADM_NO,");
		sql.append("		    TMP_AC_TYP,");
		sql.append("		    SCSN_ITM_NO,");
		sql.append("		    QTY_NSUM_TYP,");
		sql.append("		    CSLD_ITM_NO,");
		sql.append("		    CTRL_DVSN_CD,");
		sql.append("		    MFCC_CD,");
		sql.append("		    PRNT_DVSN_CD,");
		sql.append("		    DSP_SPCF_CTNT,");
		sql.append("		    IBO_CAT_CD,");
		sql.append("		    FMCC_DPT_NM,");
		sql.append("		    FMCC_CHRG_NM,");
		sql.append("		    PRV_ITM_NO,");
		sql.append("		    CLR_CD,");
		sql.append("		    BRND_CD,");
		sql.append("		    HS_CD,");
		sql.append("		    ACC_CAT_CD,");
		sql.append("		    ITM_NM_ENG,");
		sql.append("		    SLS_QTY_UN_CD,");
		sql.append("		    SLC_PRMT_ITM_TYP,");
		sql.append("		    KIT_TYP,");
		sql.append("		    GFT_TYP,");
		sql.append("		    FOC_TYP,");
		sql.append("		    MIN_ODR_QTY,");
		sql.append("		    STD_PKG_SZ,");
		sql.append("		    STD_PKG_WDTH,");
		sql.append("		    STD_PKG_HI,");
		sql.append("		    STD_PKG_WGT,");
		sql.append("		    TMP_PRIZ_TYP,");
		sql.append("		    STD_UP,");
		sql.append("		    ITM_NM_CN,");
		sql.append("		    SLS_ROUT_TYP,");
		sql.append("		    RGS_DTTM,");
		sql.append("		    RGS_CHRG_CD,");
		sql.append("		    RGS_PGID,");
		sql.append("		    UPD_DTTM,");
		sql.append("		    UPD_CHRG_CD,");
		sql.append("		    UPD_PGID,");
		sql.append("		    FM_TYP");
		sql.append("		    FROM");
		sql.append("		    M02");
		sql.append("		    WHERE");
		sql.append("		   ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"	    ");
		sql.append("		   AND  ");
		sql.append("		   ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+"");
		sql.append("		   AND  ");
		sql.append("		   APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		sql.append("		   AND");
		sql.append("		   FM_TYP "+((getString("FM").equals(""))?" is null ":"=")+getString("FM")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public int INSERT_BM0212(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		    INSERT INTO");
		sql.append("		    BM02");
		sql.append("		    (");
		sql.append("		    SEQ_NO,");
		sql.append("		    ITM_NO,");
		sql.append("		    ODR_DVSN_CD,");
		sql.append("		    APL_BDT,");
		sql.append("		    APL_EDT,");
		sql.append("		    GNR_ADM_NO,");
		sql.append("		    TMP_AC_TYP,");
		sql.append("		    SCSN_ITM_NO,");
		sql.append("		    QTY_NSUM_TYP,");
		sql.append("		    CSLD_ITM_NO,");
		sql.append("		    CTRL_DVSN_CD,");
		sql.append("		    MFCC_CD,");
		sql.append("		    PRNT_DVSN_CD,");
		sql.append("		    DSP_SPCF_CTNT,");
		sql.append("		    IBO_CAT_CD,");
		sql.append("		    FMCC_DPT_NM,");
		sql.append("		    FMCC_CHRG_NM,");
		sql.append("		    PRV_ITM_NO,");
		sql.append("		    CLR_CD,");
		sql.append("		    BRND_CD,");
		sql.append("		    HS_CD,");
		sql.append("		    ACC_CAT_CD,");
		sql.append("		    ITM_NM_ENG,");
		sql.append("		    SLS_QTY_UN_CD,");
		sql.append("		    SLC_PRMT_ITM_TYP,");
		sql.append("		    KIT_TYP,");
		sql.append("		    GFT_TYP,");
		sql.append("		    FOC_TYP,");
		sql.append("		    MIN_ODR_QTY,");
		sql.append("		    STD_PKG_SZ,");
		sql.append("		    STD_PKG_WDTH,");
		sql.append("		    STD_PKG_HI,");
		sql.append("		    STD_PKG_WGT,");
		sql.append("		    TMP_PRIZ_TYP,");
		sql.append("		    STD_UP,");
		sql.append("		    ITM_NM_CN,");
		sql.append("		    SLS_ROUT_TYP,");
		sql.append("		    RGS_DTTM,");
		sql.append("		    RGS_CHRG_CD,");
		sql.append("		    RGS_PGID,");
		sql.append("		    UPD_DTTM,");
		sql.append("		    UPD_CHRG_CD,");
		sql.append("		    UPD_PGID,");
		sql.append("		    FM_TYP");
		sql.append("		    )");
		sql.append("		    SELECT");
		sql.append("		    SEQ_BM02.NEXTVAL,");
		sql.append("		    ITM_NO,");
		sql.append("		    ODR_DVSN_CD,");
		sql.append("		    APL_BDT,");
		sql.append("		    APL_EDT,");
		sql.append("		    GNR_ADM_NO,");
		sql.append("		    TMP_AC_TYP,");
		sql.append("		    SCSN_ITM_NO,");
		sql.append("		    QTY_NSUM_TYP,");
		sql.append("		    CSLD_ITM_NO,");
		sql.append("		    CTRL_DVSN_CD,");
		sql.append("		    MFCC_CD,");
		sql.append("		    PRNT_DVSN_CD,");
		sql.append("		    DSP_SPCF_CTNT,");
		sql.append("		    IBO_CAT_CD,");
		sql.append("		    FMCC_DPT_NM,");
		sql.append("		    FMCC_CHRG_NM,");
		sql.append("		    PRV_ITM_NO,");
		sql.append("		    CLR_CD,");
		sql.append("		    BRND_CD,");
		sql.append("		    HS_CD,");
		sql.append("		    ACC_CAT_CD,");
		sql.append("		    ITM_NM_ENG,");
		sql.append("		    SLS_QTY_UN_CD,");
		sql.append("		    SLC_PRMT_ITM_TYP,");
		sql.append("		    KIT_TYP,");
		sql.append("		    GFT_TYP,");
		sql.append("		    FOC_TYP,");
		sql.append("		    MIN_ODR_QTY,");
		sql.append("		    STD_PKG_SZ,");
		sql.append("		    STD_PKG_WDTH,");
		sql.append("		    STD_PKG_HI,");
		sql.append("		    STD_PKG_WGT,");
		sql.append("		    TMP_PRIZ_TYP,");
		sql.append("		    STD_UP,");
		sql.append("		    ITM_NM_CN,");
		sql.append("		    SLS_ROUT_TYP,");
		sql.append("		    RGS_DTTM,");
		sql.append("		    RGS_CHRG_CD,");
		sql.append("		    RGS_PGID,");
		sql.append("		    UPD_DTTM,");
		sql.append("		    UPD_CHRG_CD,");
		sql.append("		    UPD_PGID,");
		sql.append("		    FM_TYP");
		sql.append("		    FROM		");
		sql.append("		    M02");
		sql.append("		    WHERE");
		sql.append("		    ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"	    ");
		sql.append("		    AND  ");
		sql.append("		    ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+" ");
		sql.append("		    AND  ");
		sql.append("		    APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		sql.append("		    AND");
		sql.append("		    FM_TYP "+((getString("FM").equals(""))?" is null ":"=")+getString("FM")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int DELETE_M0213(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("			DELETE");
		sql.append("			FROM");
		sql.append("			M02");
		sql.append("			WHERE");
		sql.append("			ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"	    ");
		sql.append("			AND  ");
		sql.append("			ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+"");
		sql.append("			AND");
		sql.append("			FM_TYP "+((getString("FM").equals(""))?" is null ":"=")+getString("FM")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int INSERT_BM0214(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		    INSERT INTO");
		sql.append("		    BM02");
		sql.append("		    (");
		sql.append("		    SEQ_NO,");
		sql.append("		    ITM_NO,");
		sql.append("		    ODR_DVSN_CD,");
		sql.append("		    APL_BDT,");
		sql.append("		    APL_EDT,");
		sql.append("		    GNR_ADM_NO,");
		sql.append("		    TMP_AC_TYP,");
		sql.append("		    SCSN_ITM_NO,");
		sql.append("		    QTY_NSUM_TYP,");
		sql.append("		    CSLD_ITM_NO,");
		sql.append("		    CTRL_DVSN_CD,");
		sql.append("		    MFCC_CD,");
		sql.append("		    PRNT_DVSN_CD,");
		sql.append("		    DSP_SPCF_CTNT,");
		sql.append("		    IBO_CAT_CD,");
		sql.append("		    FMCC_DPT_NM,");
		sql.append("		    FMCC_CHRG_NM,");
		sql.append("		    PRV_ITM_NO,");
		sql.append("		    CLR_CD,");
		sql.append("		    BRND_CD,");
		sql.append("		    HS_CD,");
		sql.append("		    ACC_CAT_CD,");
		sql.append("		    ITM_NM_ENG,");
		sql.append("		    SLS_QTY_UN_CD,");
		sql.append("		    SLC_PRMT_ITM_TYP,");
		sql.append("		    KIT_TYP,");
		sql.append("		    GFT_TYP,");
		sql.append("		    FOC_TYP,");
		sql.append("		    MIN_ODR_QTY,");
		sql.append("		    STD_PKG_SZ,");
		sql.append("		    STD_PKG_WDTH,");
		sql.append("		    STD_PKG_HI,");
		sql.append("		    STD_PKG_WGT,");
		sql.append("		    TMP_PRIZ_TYP,");
		sql.append("		    STD_UP,");
		sql.append("		    ITM_NM_CN,");
		sql.append("		    SLS_ROUT_TYP,");
		sql.append("		    RGS_DTTM,");
		sql.append("		    RGS_CHRG_CD,");
		sql.append("		    RGS_PGID,");
		sql.append("		    UPD_DTTM,");
		sql.append("		    UPD_CHRG_CD,");
		sql.append("		    UPD_PGID,");
		sql.append("		    FM_TYP");
		sql.append("		    )");
		sql.append("		    SELECT");
		sql.append("		    SEQ_BM02.NEXTVAL,");
		sql.append("		    ITM_NO,");
		sql.append("		    ODR_DVSN_CD,");
		sql.append("		    APL_BDT,");
		sql.append("		    APL_EDT,");
		sql.append("		    GNR_ADM_NO,");
		sql.append("		    TMP_AC_TYP,");
		sql.append("		    SCSN_ITM_NO,");
		sql.append("		    QTY_NSUM_TYP,");
		sql.append("		    CSLD_ITM_NO,");
		sql.append("		    CTRL_DVSN_CD,");
		sql.append("		    MFCC_CD,");
		sql.append("		    PRNT_DVSN_CD,");
		sql.append("		    DSP_SPCF_CTNT,");
		sql.append("		    IBO_CAT_CD,");
		sql.append("		    FMCC_DPT_NM,");
		sql.append("		    FMCC_CHRG_NM,");
		sql.append("		    PRV_ITM_NO,");
		sql.append("		    CLR_CD,");
		sql.append("		    BRND_CD,");
		sql.append("		    HS_CD,");
		sql.append("		    ACC_CAT_CD,");
		sql.append("		    ITM_NM_ENG,");
		sql.append("		    SLS_QTY_UN_CD,");
		sql.append("		    SLC_PRMT_ITM_TYP,");
		sql.append("		    KIT_TYP,");
		sql.append("		    GFT_TYP,");
		sql.append("		    FOC_TYP,");
		sql.append("		    MIN_ODR_QTY,");
		sql.append("		    STD_PKG_SZ,");
		sql.append("		    STD_PKG_WDTH,");
		sql.append("		    STD_PKG_HI,");
		sql.append("		    STD_PKG_WGT,");
		sql.append("		    TMP_PRIZ_TYP,");
		sql.append("		    STD_UP,");
		sql.append("		    ITM_NM_CN,");
		sql.append("		    SLS_ROUT_TYP,");
		sql.append("		    RGS_DTTM,");
		sql.append("		    RGS_CHRG_CD,");
		sql.append("		    RGS_PGID,");
		sql.append("		    UPD_DTTM,");
		sql.append("		    UPD_CHRG_CD,");
		sql.append("		    UPD_PGID,");
		sql.append("		    FM_TYP");
		sql.append("		    FROM		");
		sql.append("		    M02");
		sql.append("		    WHERE");
		sql.append("		    ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"	    ");
		sql.append("		    AND  ");
		sql.append("		    ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+"");
		sql.append("		    AND  ");
		sql.append("		    APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int UPDATE_M0215(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		UPDATE");
		sql.append("		M02 ");
		sql.append("		SET");
		sql.append("		FM_TYP "+((getString("FM8").equals(""))?" is null ":"=")+getString("FM8")+",");
		sql.append("		APL_EDT "+((getString("ENDDATE").equals(""))?" is null ":"=")+getString("ENDDATE")+"");
		sql.append("		WHERE  ");
		sql.append("		ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"	     ");
		sql.append("		AND  ");
		sql.append("		ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+"");
		sql.append("		AND");
		sql.append("		APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		sql.append("		AND");
		sql.append("		FM_TYP "+((getString("FM9").equals(""))?" is null ":"=")+getString("FM9")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public SelectResultRset SELECT_M0216(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		    SELECT");
		sql.append("		    ITM_NO,");
		sql.append("		    ODR_DVSN_CD,");
		sql.append("		    APL_BDT,");
		sql.append("		    APL_EDT,");
		sql.append("		    GNR_ADM_NO,");
		sql.append("		    TMP_AC_TYP,");
		sql.append("		    SCSN_ITM_NO,");
		sql.append("		    QTY_NSUM_TYP,");
		sql.append("		    CSLD_ITM_NO,");
		sql.append("		    CTRL_DVSN_CD,");
		sql.append("		    MFCC_CD,");
		sql.append("		    PRNT_DVSN_CD,");
		sql.append("		    DSP_SPCF_CTNT,");
		sql.append("		    IBO_CAT_CD,");
		sql.append("		    FMCC_DPT_NM,");
		sql.append("		    FMCC_CHRG_NM,");
		sql.append("		    PRV_ITM_NO,");
		sql.append("		    CLR_CD,");
		sql.append("		    BRND_CD,");
		sql.append("		    HS_CD,");
		sql.append("		    ACC_CAT_CD,");
		sql.append("		    ITM_NM_ENG,");
		sql.append("		    SLS_QTY_UN_CD,");
		sql.append("		    SLC_PRMT_ITM_TYP,");
		sql.append("		    KIT_TYP,");
		sql.append("		    GFT_TYP,");
		sql.append("		    FOC_TYP,");
		sql.append("		    MIN_ODR_QTY,");
		sql.append("		    STD_PKG_SZ,");
		sql.append("		    STD_PKG_WDTH,");
		sql.append("		    STD_PKG_HI,");
		sql.append("		    STD_PKG_WGT,");
		sql.append("		    TMP_PRIZ_TYP,");
		sql.append("		    STD_UP,");
		sql.append("		    ITM_NM_CN,");
		sql.append("		    SLS_ROUT_TYP,");
		sql.append("		    RGS_DTTM,");
		sql.append("		    RGS_CHRG_CD,");
		sql.append("		    RGS_PGID,");
		sql.append("		    UPD_DTTM,");
		sql.append("		    UPD_CHRG_CD,");
		sql.append("		    UPD_PGID,");
		sql.append("		    FM_TYP");
		sql.append("		    FROM");
		sql.append("		    M02");
		sql.append("		    WHERE");
		sql.append("		   ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"	    ");
		sql.append("		   AND  ");
		sql.append("		   ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+"");
		sql.append("		   AND");
		sql.append("		   FM_TYP "+((getString("FM").equals(""))?" is null ":"=")+getString("FM")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_M0217(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		    SELECT");
		sql.append("		    ITM_NO,");
		sql.append("		    ODR_DVSN_CD,");
		sql.append("		    APL_BDT,");
		sql.append("		    APL_EDT,");
		sql.append("		    GNR_ADM_NO,");
		sql.append("		    TMP_AC_TYP,");
		sql.append("		    SCSN_ITM_NO,");
		sql.append("		    QTY_NSUM_TYP,");
		sql.append("		    CSLD_ITM_NO,");
		sql.append("		    CTRL_DVSN_CD,");
		sql.append("		    MFCC_CD,");
		sql.append("		    PRNT_DVSN_CD,");
		sql.append("		    DSP_SPCF_CTNT,");
		sql.append("		    IBO_CAT_CD,");
		sql.append("		    FMCC_DPT_NM,");
		sql.append("		    FMCC_CHRG_NM,");
		sql.append("		    PRV_ITM_NO,");
		sql.append("		    CLR_CD,");
		sql.append("		    BRND_CD,");
		sql.append("		    HS_CD,");
		sql.append("		    ACC_CAT_CD,");
		sql.append("		    ITM_NM_ENG,");
		sql.append("		    SLS_QTY_UN_CD,");
		sql.append("		    SLC_PRMT_ITM_TYP,");
		sql.append("		    KIT_TYP,");
		sql.append("		    GFT_TYP,");
		sql.append("		    FOC_TYP,");
		sql.append("		    MIN_ODR_QTY,");
		sql.append("		    STD_PKG_SZ,");
		sql.append("		    STD_PKG_WDTH,");
		sql.append("		    STD_PKG_HI,");
		sql.append("		    STD_PKG_WGT,");
		sql.append("		    TMP_PRIZ_TYP,");
		sql.append("		    STD_UP,");
		sql.append("		    ITM_NM_CN,");
		sql.append("		    SLS_ROUT_TYP,");
		sql.append("		    RGS_DTTM,");
		sql.append("		    RGS_CHRG_CD,");
		sql.append("		    RGS_PGID,");
		sql.append("		    UPD_DTTM,");
		sql.append("		    UPD_CHRG_CD,");
		sql.append("		    UPD_PGID,");
		sql.append("		    FM_TYP");
		sql.append("		    FROM");
		sql.append("		    M02");
		sql.append("		    WHERE");
		sql.append("		    ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"	     ");
		sql.append("		    AND  ");
		sql.append("		    ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public int INSERT_BM0218(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		    INSERT INTO");
		sql.append("		    BM02");
		sql.append("		    (");
		sql.append("		    SEQ_NO,");
		sql.append("		    ITM_NO,");
		sql.append("		    ODR_DVSN_CD,");
		sql.append("		    APL_BDT,");
		sql.append("		    APL_EDT,");
		sql.append("		    GNR_ADM_NO,");
		sql.append("		    TMP_AC_TYP,");
		sql.append("		    SCSN_ITM_NO,");
		sql.append("		    QTY_NSUM_TYP,");
		sql.append("		    CSLD_ITM_NO,");
		sql.append("		    CTRL_DVSN_CD,");
		sql.append("		    MFCC_CD,");
		sql.append("		    PRNT_DVSN_CD,");
		sql.append("		    DSP_SPCF_CTNT,");
		sql.append("		    IBO_CAT_CD,");
		sql.append("		    FMCC_DPT_NM,");
		sql.append("		    FMCC_CHRG_NM,");
		sql.append("		    PRV_ITM_NO,");
		sql.append("		    CLR_CD,");
		sql.append("		    BRND_CD,");
		sql.append("		    HS_CD,");
		sql.append("		    ACC_CAT_CD,");
		sql.append("		    ITM_NM_ENG,");
		sql.append("		    SLS_QTY_UN_CD,");
		sql.append("		    SLC_PRMT_ITM_TYP,");
		sql.append("		    KIT_TYP,");
		sql.append("		    GFT_TYP,");
		sql.append("		    FOC_TYP,");
		sql.append("		    MIN_ODR_QTY,");
		sql.append("		    STD_PKG_SZ,");
		sql.append("		    STD_PKG_WDTH,");
		sql.append("		    STD_PKG_HI,");
		sql.append("		    STD_PKG_WGT,");
		sql.append("		    TMP_PRIZ_TYP,");
		sql.append("		    STD_UP,");
		sql.append("		    ITM_NM_CN,");
		sql.append("		    SLS_ROUT_TYP,");
		sql.append("		    RGS_DTTM,");
		sql.append("		    RGS_CHRG_CD,");
		sql.append("		    RGS_PGID,");
		sql.append("		    UPD_DTTM,");
		sql.append("		    UPD_CHRG_CD,");
		sql.append("		    UPD_PGID,");
		sql.append("		    FM_TYP");
		sql.append("		    )");
		sql.append("		    SELECT");
		sql.append("		    SEQ_BM02.NEXTVAL,");
		sql.append("		    ITM_NO,");
		sql.append("		    ODR_DVSN_CD,");
		sql.append("		    APL_BDT,");
		sql.append("		    APL_EDT,");
		sql.append("		    GNR_ADM_NO,");
		sql.append("		    TMP_AC_TYP,");
		sql.append("		    SCSN_ITM_NO,");
		sql.append("		    QTY_NSUM_TYP,");
		sql.append("		    CSLD_ITM_NO,");
		sql.append("		    CTRL_DVSN_CD,");
		sql.append("		    MFCC_CD,");
		sql.append("		    PRNT_DVSN_CD,");
		sql.append("		    DSP_SPCF_CTNT,");
		sql.append("		    IBO_CAT_CD,");
		sql.append("		    FMCC_DPT_NM,");
		sql.append("		    FMCC_CHRG_NM,");
		sql.append("		    PRV_ITM_NO,");
		sql.append("		    CLR_CD,");
		sql.append("		    BRND_CD,");
		sql.append("		    HS_CD,");
		sql.append("		    ACC_CAT_CD,");
		sql.append("		    ITM_NM_ENG,");
		sql.append("		    SLS_QTY_UN_CD,");
		sql.append("		    SLC_PRMT_ITM_TYP,");
		sql.append("		    KIT_TYP,");
		sql.append("		    GFT_TYP,");
		sql.append("		    FOC_TYP,");
		sql.append("		    MIN_ODR_QTY,");
		sql.append("		    STD_PKG_SZ,");
		sql.append("		    STD_PKG_WDTH,");
		sql.append("		    STD_PKG_HI,");
		sql.append("		    STD_PKG_WGT,");
		sql.append("		    TMP_PRIZ_TYP,");
		sql.append("		    STD_UP,");
		sql.append("		    ITM_NM_CN,");
		sql.append("		    SLS_ROUT_TYP,");
		sql.append("		    RGS_DTTM,");
		sql.append("		    RGS_CHRG_CD,");
		sql.append("		    RGS_PGID,");
		sql.append("		    UPD_DTTM,");
		sql.append("		    UPD_CHRG_CD,");
		sql.append("		    UPD_PGID,");
		sql.append("		    FM_TYP");
		sql.append("		    FROM		");
		sql.append("		    M02");
		sql.append("		    WHERE");
		sql.append("		    ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"	    ");
		sql.append("		    AND  ");
		sql.append("		    ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+" ");
		sql.append("		    AND");
		sql.append("		    FM_TYP "+((getString("FM").equals(""))?" is null ":"=")+getString("FM")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public SelectResultRset SELECT_MDLNO19(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		SELECT  ");
		sql.append("		COUNT(UNI_ITM_NO) AS COUNT");
		sql.append("		FROM");
		sql.append("		MDLNO     ");
		sql.append("		WHERE ");
		sql.append("		UNI_ITM_NO  "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("		AND  ");
		sql.append("		APL_BDT <"+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		sql.append("		AND");
		sql.append("		AC_END_DT >"+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_PMDLNO20(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		SELECT ");
		sql.append("		NVL(MDLNO      ,'') AS MDLNO,");
		sql.append("		NVL(SUP_CD     ,'') AS SUP_CD,");
		sql.append("		NVL(MFC_CD     ,'') AS MFC_CD,");
		sql.append("		NVL(SLS_DEPT_CD,'') AS SLS_DEPT_CD,");
		sql.append("		NVL(CLR_CD     ,'') AS CLR_CD,");
		sql.append("		NVL(BRND_CD    ,'') AS BRND_CD,");
		sql.append("		NVL(O_MDLNO    ,'') AS O_MDLNO,");
		sql.append("		NVL(HS_CD      ,'') AS HS_CD,");
		sql.append("		NVL(ACC_CAT    ,'') AS ACC_CAT,");
		sql.append("		NVL(OVS_CAT    ,'') AS OVS_CAT,");
		sql.append("		NVL(AVD_ID     ,'') AS AVD_ID,");
		sql.append("		NVL(R_QTY_ID   ,'') AS R_QTY_ID,");
		sql.append("		NVL(M_ACC_QTY  ,'') AS M_ACC_QTY,");
		sql.append("		NVL(DEC_P      ,'') AS DEC_P,");
		sql.append("		NVL(UNIT_CD    ,'') AS UNIT_CD,");
		sql.append("		NVL(IND_MDLNO  ,'') AS IND_MDLNO,");
		sql.append("		NVL(KIT_ID     ,'') AS KIT_ID,");
		sql.append("		NVL(CCM_ID     ,'') AS CCM_ID,");
		sql.append("		NVL(CMDY_NM    ,'') AS CMDY_NM,");
		sql.append("		NVL(DEPT       ,'') AS DEPT,");
		sql.append("		NVL(NM         ,'') AS NM,");
		sql.append("		NVL(PTNR_CD    ,'') AS PTNR_CD ");
		sql.append("		FROM ");
		sql.append("		PMDLNO ");
		sql.append("		WHERE ");
		sql.append("		MDLNO "+((getString("MDLNO").equals(""))?" is null ":"=")+getString("MDLNO")+" ");
		sql.append("		AND ");
		sql.append("		SUP_CD "+((getString("SUP_CD").equals(""))?" is null ":"=")+getString("SUP_CD")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_INTIC21(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		SELECT ");
		sql.append("		NVL(ITM_NO,        '') AS ITM_NO,");
		sql.append("		NVL(APL_BDT,       '') AS APL_BDT,");
		sql.append("		NVL(APL_EDT,       '') AS APL_EDT,");
		sql.append("		NVL(GNR_ADM_NO,    '') AS GNR_ADM_NO,");
		sql.append("		NVL(SCSN_ITM_NO,   '') AS SCSN_ITM_NO,");
		sql.append("		NVL(QTY_NSUM_TYP,  '') AS QTY_NSUM_TYP,");
		sql.append("		NVL(CSLD_ITM_NO,   '') AS CSLD_ITM_NO,");
		sql.append("		NVL(RGS_DTTM,      '') AS RGS_DTTM,");
		sql.append("		NVL(RGS_USR_CD,    '') AS RGS_USR_CD,");
		sql.append("		NVL(UPD_DTTM,      '') AS UPD_DTTM,");
		sql.append("		NVL(UPD_USR_CD,    '') AS UPD_USR_CD,");
		sql.append("		NVL(LC_RGS_DTTM,   '') AS LC_RGS_DTTM,");
		sql.append("		NVL(LCL_UPD_DTTM,  '') AS LCL_UPD_DTTM,");
		sql.append("		NVL(FNL_UPD_PGM_ID,'') AS FNL_UPD_PGM_ID,");
		sql.append("		NVL(DEL_TYP,   	'') AS DEL_TYP ");
		sql.append("		FROM ");
		sql.append("		INTIC ");
		sql.append("		WHERE ");
		sql.append("		ITM_NO	"+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("		AND ");
		sql.append("		APL_BDT <"+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+" ");
		sql.append("		AND ");
		sql.append("		APL_EDT >"+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+" ");
		sql.append("		ORDER BY GNR_ADM_NO DESC");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_M0222(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		SELECT  ");
		sql.append("		COUNT(ITM_NO) AS COUNT");
		sql.append("		FROM");
		sql.append("		M02");
		sql.append("		WHERE");
		sql.append("		ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("		AND");
		sql.append("		ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+"");
		sql.append("		AND");
		sql.append("		APL_BDT <"+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		sql.append("		AND");
		sql.append("		FM_TYP <>  "+getString("FM6")+"");
		sql.append("		AND");
		sql.append("		FM_TYP <>  "+getString("FM9")+"             ");
		sql.append("		");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public int INSERT_M029901(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("INSERT INTO ");
		sql.append("M02(");
		sql.append("ITM_NO,");
		sql.append("ODR_DVSN_CD,");
		sql.append("APL_BDT,");
		sql.append("APL_EDT,");
		sql.append("GNR_ADM_NO,");
		sql.append("TMP_AC_TYP,");
		sql.append("SCSN_ITM_NO,");
		sql.append("QTY_NSUM_TYP,");
		sql.append("CSLD_ITM_NO,");
		sql.append("CTRL_DVSN_CD,");
		sql.append("MFCC_CD,");
		sql.append("PRNT_DVSN_CD,");
		sql.append("DSP_SPCF_CTNT,");
		sql.append("IBO_CAT_CD,");
		sql.append("FMCC_DPT_NM,");
		sql.append("FMCC_CHRG_NM,");
		sql.append("PRV_ITM_NO,");
		sql.append("CLR_CD,");
		sql.append("BRND_CD,");
		sql.append("HS_CD,");
		sql.append("ACC_CAT_CD,");
		sql.append("ITM_NM_ENG,");
		sql.append("SLS_QTY_UN_CD,");
		sql.append("SLC_PRMT_ITM_TYP,");
		sql.append("KIT_TYP,");
		sql.append("GFT_TYP,");
		sql.append("FOC_TYP,");
		sql.append("MIN_ODR_QTY,");
		sql.append("STD_PKG_SZ,");
		sql.append("STD_PKG_WDTH,");
		sql.append("STD_PKG_HI,");
		sql.append("STD_PKG_WGT,");
		sql.append("TMP_PRIZ_TYP,");
		sql.append("STD_UP,");
		sql.append("ITM_NM_CN,");
		sql.append("SLS_ROUT_TYP,");
		sql.append("ITM_NET_WGT,");
		sql.append("RGS_DTTM,");
		sql.append("RGS_CHRG_CD,");
		sql.append("RGS_PGID,");
		sql.append("UPD_DTTM,");
		sql.append("UPD_CHRG_CD,");
		sql.append("UPD_PGID,");
		sql.append("FM_TYP");
		sql.append(")");
		sql.append("VALUES");
		sql.append("(");
		sql.append(""+getString("ITM_NO")+",");
		sql.append(""+getString("ODR_DVSN_CD")+",");
		sql.append(""+getString("APL_BDT")+",");
		sql.append(""+getString("APL_EDT")+",");
		sql.append(""+getString("GNR_ADM_NO")+",");
		sql.append(""+getString("TMP_AC_TYP")+",");
		sql.append(""+getString("SCSN_ITM_NO")+",");
		sql.append(""+getString("QTY_NSUM_TYP")+",");
		sql.append(""+getString("CSLD_ITM_NO")+",");
		sql.append(""+getString("CTRL_DVSN_CD")+",");
		sql.append(""+getString("MFCC_CD")+",");
		sql.append(""+getString("PRNT_DVSN_CD")+",");
		sql.append(""+getString("DSP_SPCF_CTNT")+",");
		sql.append(""+getString("IBO_CAT_CD")+",");
		sql.append(""+getString("FMCC_DPT_NM")+",");
		sql.append(""+getString("FMCC_CHRG_NM")+",");
		sql.append(""+getString("PRV_ITM_NO")+",");
		sql.append(""+getString("CLR_CD")+",");
		sql.append(""+getString("BRND_CD")+",");
		sql.append(""+getString("HS_CD")+",");
		sql.append(""+getString("ACC_CAT_CD")+",");
		sql.append(""+getString("ITM_NM_ENG")+",");
		sql.append(""+getString("SLS_QTY_UN_CD")+",");
		sql.append(""+getString("SLC_PRMT_ITM_TYP")+",");
		sql.append(""+getString("KIT_TYP")+",");
		sql.append(""+getString("GFT_TYP")+",");
		sql.append(""+getString("FOC_TYP")+",");
		sql.append(""+getString("MIN_ODR_QTY")+",");
		sql.append(""+getString("STD_PKG_SZ")+",");
		sql.append(""+getString("STD_PKG_WDTH")+",");
		sql.append(""+getString("STD_PKG_HI")+",");
		sql.append(""+getString("STD_PKG_WGT")+",");
		sql.append(""+getString("TMP_PRIZ_TYP")+",");
		sql.append(""+getString("STD_UP")+",");
		sql.append(""+getString("ITM_NM_CN")+",");
		sql.append(""+getString("SLS_ROUT_TYP")+",");
		sql.append(""+getString("ITM_NET_WGT")+",");
		sql.append("TO_DATE("+getString("RGS_DTTM")+",'YYYYMMDD HH24:MI:SS'),");
		sql.append(""+getString("RGS_CHRG_CD")+",");
		sql.append(""+getString("RGS_PGID")+",");
		sql.append("TO_DATE("+getString("UPD_DTTM")+",'YYYYMMDD HH24:MI:SS'),");
		sql.append(""+getString("UPD_CHRG_CD")+",");
		sql.append(""+getString("UPD_PGID")+",");
		sql.append(""+getString("FM_TYP")+"");
		sql.append(")");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public SelectResultRset SELECT_M029901(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("	SELECT");
		sql.append("	COUNT(*) AS COUNTS");
		sql.append("	FROM ");
		sql.append("	M02 ");
		sql.append("	WHERE");
		sql.append("	ODR_DVSN_CD  "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+"");
		sql.append("	AND ");
		sql.append("	ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("	AND ");
		sql.append("	APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		sql.append("	AND ");
		sql.append("	FM_TYP <> "+getString("NOT_FM_TYP")+"");
		sql.append("	"+getFree("OTHERS")+"");
		sql.append("	");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_M029902(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("	SELECT");
		sql.append("	APL_BDT");
		sql.append("	FROM ");
		sql.append("	M02 ");
		sql.append("	WHERE");
		sql.append("	ODR_DVSN_CD  "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+"");
		sql.append("	AND ");
		sql.append("	ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("	AND");
		sql.append("	FM_TYP <> "+getString("FM_TYP_9")+"");
		sql.append("	AND ");
		sql.append("	APL_BDT = (");
		sql.append("	SELECT MAX(APL_BDT)");
		sql.append("	FROM");
		sql.append("	M02");
		sql.append("	WHERE");
		sql.append("	ODR_DVSN_CD  "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+"");
		sql.append("	AND ");
		sql.append("	ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("	AND ");
		sql.append("	FM_TYP <> "+getString("FM_TYP_6")+"");
		sql.append("	)");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_M029903(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("SELECT ");
		sql.append("APL_BDT,");
		sql.append("APL_EDT,");
		sql.append("FM_TYP ");
		sql.append("FROM ");
		sql.append("M02 ");
		sql.append("WHERE ");
		sql.append("ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+" ");
		sql.append("AND ");
		sql.append("ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND ");
		sql.append("APL_BDT"+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+" 	");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_M029904(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("SELECT ");
		sql.append("COUNT(*) AS COUNTS ");
		sql.append("FROM ");
		sql.append("M02 ");
		sql.append("WHERE ");
		sql.append("ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+" ");
		sql.append("AND ");
		sql.append("ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset 	SELECT_M029905(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("SELECT  ");
		sql.append("NVL(ITM_NO, '') AS               ITM_NO,          ");
		sql.append("NVL(ODR_DVSN_CD, '') AS          ODR_DVSN_CD,     ");
		sql.append("NVL(APL_BDT, '') AS              APL_BDT,         ");
		sql.append("NVL(APL_EDT, '') AS              APL_EDT,         ");
		sql.append("NVL(GNR_ADM_NO, '') AS           GNR_ADM_NO,      ");
		sql.append("NVL(TMP_AC_TYP, '') AS           TMP_AC_TYP,      ");
		sql.append("NVL(SCSN_ITM_NO, '') AS          SCSN_ITM_NO,     ");
		sql.append("NVL(QTY_NSUM_TYP, '') AS         QTY_NSUM_TYP,    ");
		sql.append("NVL(CSLD_ITM_NO, '') AS          CSLD_ITM_NO,     ");
		sql.append("NVL(CTRL_DVSN_CD, '') AS         CTRL_DVSN_CD,    ");
		sql.append("NVL(MFCC_CD, '') AS              MFCC_CD,         ");
		sql.append("NVL(PRNT_DVSN_CD, '') AS         PRNT_DVSN_CD,    ");
		sql.append("NVL(DSP_SPCF_CTNT, '') AS        DSP_SPCF_CTNT,   ");
		sql.append("NVL(IBO_CAT_CD, '') AS           IBO_CAT_CD,      ");
		sql.append("NVL(FMCC_DPT_NM, '') AS          FMCC_DPT_NM,     ");
		sql.append("NVL(FMCC_CHRG_NM, '') AS         FMCC_CHRG_NM,    ");
		sql.append("NVL(PRV_ITM_NO, '') AS           PRV_ITM_NO,      ");
		sql.append("NVL(CLR_CD, '') AS               CLR_CD,          ");
		sql.append("NVL(BRND_CD, '') AS              BRND_CD,         ");
		sql.append("NVL(HS_CD, '') AS                HS_CD,           ");
		sql.append("NVL(ACC_CAT_CD, '') AS           ACC_CAT_CD,      ");
		sql.append("NVL(ITM_NM_ENG, '') AS           ITM_NM_ENG,      ");
		sql.append("NVL(SLS_QTY_UN_CD, '') AS        SLS_QTY_UN_CD,                     ");
		sql.append("NVL(SLC_PRMT_ITM_TYP, '') AS     SLC_PRMT_ITM_TYP,");
		sql.append("NVL(KIT_TYP, '') AS              KIT_TYP,         ");
		sql.append("NVL(GFT_TYP, '') AS              GFT_TYP,         ");
		sql.append("NVL(FOC_TYP, '') AS              FOC_TYP,         ");
		sql.append("NVL(MIN_ODR_QTY, '') AS          MIN_ODR_QTY,     ");
		sql.append("NVL(STD_PKG_SZ, '') AS           STD_PKG_SZ,      ");
		sql.append("NVL(STD_PKG_WDTH, '') AS         STD_PKG_WDTH,    ");
		sql.append("NVL(STD_PKG_HI, '') AS           STD_PKG_HI,      ");
		sql.append("NVL(STD_PKG_WGT, '') AS          STD_PKG_WGT,     ");
		sql.append("NVL(TMP_PRIZ_TYP, '') AS         TMP_PRIZ_TYP,    ");
		sql.append("NVL(STD_UP, '') AS               STD_UP,          ");
		sql.append("NVL(ITM_NM_CN, '') AS            ITM_NM_CN,       ");
		sql.append("NVL(SLS_ROUT_TYP, '') AS         SLS_ROUT_TYP, ");
		sql.append("NVL(ITM_NET_WGT, '')  AS         ITM_NET_WGT,    ");
		sql.append("NVL(RGS_DTTM, '') AS             RGS_DTTM,        ");
		sql.append("NVL(RGS_CHRG_CD, '') AS          RGS_CHRG_CD,     ");
		sql.append("NVL(RGS_PGID, '') AS             RGS_PGID,        ");
		sql.append("NVL(UPD_DTTM, '') AS             UPD_DTTM,        ");
		sql.append("NVL(UPD_CHRG_CD, '') AS          UPD_CHRG_CD,     ");
		sql.append("NVL(UPD_PGID, '') AS             UPD_PGID,        ");
		sql.append("NVL(FM_TYP, '') AS               FM_TYP      ");
		sql.append("FROM M02 ");
		sql.append("WHERE ");
		sql.append("ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND ");
		sql.append("ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+" ");
		sql.append("AND ");
		sql.append("FM_TYP <> "+getString("FM_TYP1")+" ");
		sql.append("AND ");
		sql.append("FM_TYP <> "+getString("FM_TYP2")+" ");
		sql.append("ORDER BY ");
		sql.append("ITM_NO,ODR_DVSN_CD,APL_BDT");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_MDLNO01(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("SELECT ");
		sql.append("NVL(UNI_ITM_NO ,    '') AS UNI_ITM_NO ,");
		sql.append("NVL(U_I_NO_DSTC_CD ,'') AS U_I_NO_DSTC_CD ,");
		sql.append("NVL(APL_BDT ,       '') AS APL_BDT ,");
		sql.append("NVL(DCAT_CD ,       '') AS DCAT_CD ,");
		sql.append("NVL(TMP_AC_TYP ,    '') AS TMP_AC_TYP ,");
		sql.append("NVL(AC_END_DT ,     '') AS AC_END_DT ,");
		sql.append("NVL(A_NOIG_DVSN_CD ,'') AS A_NOIG_DVSN_CD ,");
		sql.append("NVL(M_PRNT_DVSN_CD ,'') AS M_PRNT_DVSN_CD ,");
		sql.append("NVL(JPN_SLS_TYP ,   '') AS JPN_SLS_TYP ,");
		sql.append("NVL(EUR_SLS_TYP ,   '') AS EUR_SLS_TYP ,");
		sql.append("NVL(ASA_SLS_TYP ,   '') AS ASA_SLS_TYP ,");
		sql.append("NVL(AMRS_SLS_TYP ,  '') AS AMRS_SLS_TYP ,");
		sql.append("NVL(JPN_MFC_TYP ,   '') AS JPN_MFC_TYP ,");
		sql.append("NVL(EUR_MFC_TYP ,   '') AS EUR_MFC_TYP ,");
		sql.append("NVL(ASA_MFC_TYP ,   '') AS ASA_MFC_TYP ,");
		sql.append("NVL(AMRS_MFC_TYP ,  '') AS AMRS_MFC_TYP ,");
		sql.append("NVL(FGD_TYP ,       '') AS FGD_TYP ,");
		sql.append("NVL(PSRC_TYP ,      '') AS PSRC_TYP ,");
		sql.append("NVL(SMDL_TYP ,      '') AS SMDL_TYP ,");
		sql.append("NVL(ITM_NO_PTC_TYP ,'') AS ITM_NO_PTC_TYP ,");
		sql.append("NVL(ST_TYP_TYP ,    '') AS ST_TYP_TYP , ");
		sql.append("NVL(DMY_TYP_TYP ,   '') AS DMY_TYP_TYP ,");
		sql.append("NVL(M_PT_SYBL_TYP , '') AS M_PT_SYBL_TYP ,");
		sql.append("NVL(PT_TYP ,        '') AS PT_TYP ,");
		sql.append("NVL(PRD_BDT ,       '') AS PRD_BDT ,");
		sql.append("NVL(PRD_EDT ,       '') AS PRD_EDT ,");
		sql.append("NVL(PLRL_SLS_TYP ,  '') AS PLRL_SLS_TYP ,");
		sql.append("NVL(SLS_DVSN_CD ,   '') AS SLS_DVSN_CD ,");
		sql.append("NVL(I_N_R_PRMS_TYP ,'') AS I_N_R_PRMS_TYP ,");
		sql.append("NVL(ITM_NM1 ,       '') AS ITM_NM1 ,");
		sql.append("NVL(ITM_NM2 ,       '') AS ITM_NM2 ,");
		sql.append("NVL(MCD_PT_SYBL_CD ,'') AS MCD_PT_SYBL_CD ,");
		sql.append("NVL(JPN_POS_TYP ,   '') AS JPN_POS_TYP , ");
		sql.append("NVL(JPN_POS_CD ,    '') AS JPN_POS_CD ,");
		sql.append("NVL(EUR_POS_TYP ,   '') AS EUR_POS_TYP ,");
		sql.append("NVL(EUR_POS_CD ,    '') AS EUR_POS_CD ,");
		sql.append("NVL(ASA_POS_TYP ,   '') AS ASA_POS_TYP ,");
		sql.append("NVL(ASA_POS_CD ,    '') AS ASA_POS_CD ,");
		sql.append("NVL(LTAM_POS_TYP ,  '') AS LTAM_POS_TYP ,");
		sql.append("NVL(LTAM_POS_CD ,   '') AS LTAM_POS_CD ,");
		sql.append("NVL(NAMR_POS_TYP ,  '') AS NAMR_POS_TYP ,");
		sql.append("NVL(NAMR_POS_CD ,   '') AS NAMR_POS_CD ,");
		sql.append("NVL(E_RGN_POS_TYP , '') AS E_RGN_POS_TYP ,");
		sql.append("NVL(ETC_RGN_POS_CD ,'') AS ETC_RGN_POS_CD ,");
		sql.append("NVL(O_CPRS_ITM_NO , '') AS O_CPRS_ITM_NO ,");
		sql.append("NVL(O_CPRS_ITM_CD , '') AS O_CPRS_ITM_CD ,");
		sql.append("NVL(DEL_TYP ,       '') AS DEL_TYP ,");
		sql.append("NVL(RGS_PGM_NM ,    '') AS RGS_PGM_NM ,");
		sql.append("NVL(RGS_USR_ID ,    '') AS RGS_USR_ID ,");
		sql.append("NVL(RGS_DTTM ,      '') AS RGS_DTTM ,");
		sql.append("NVL(CHG_PGM_NM ,    '') AS CHG_PGM_NM ,");
		sql.append("NVL(CHG_USR_ID ,    '') AS CHG_USR_ID ,");
		sql.append("NVL(CHG_DTTM ,      '') AS CHG_DTTM ,");
		sql.append("NVL(CHG_TMS ,       '') AS CHG_TMS ");
		sql.append("FROM MDLNO ");
		sql.append("WHERE ");
		sql.append("UNI_ITM_NO "+((getString("UNI_ITM_NO").equals(""))?" is null ":"=")+getString("UNI_ITM_NO")+" ");
		sql.append("AND ");
		sql.append("APL_BDT <"+((getString("nowDate").equals(""))?" is null ":"=")+getString("nowDate")+"  ");
		sql.append("AND ");
		sql.append("AC_END_DT >"+((getString("nowDate").equals(""))?" is null ":"=")+getString("nowDate")+" ");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_PMDLNO01(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("SELECT ");
		sql.append("NVL(MDLNO      ,'') AS MDLNO      ,");
		sql.append("NVL(SUP_CD     ,'') AS SUP_CD     ,");
		sql.append("NVL(MFC_CD     ,'') AS MFC_CD     ,");
		sql.append("NVL(SLS_DEPT_CD,'') AS SLS_DEPT_CD,");
		sql.append("NVL(CLR_CD     ,'') AS CLR_CD     ,");
		sql.append("NVL(BRND_CD    ,'') AS BRND_CD    ,");
		sql.append("NVL(O_MDLNO    ,'') AS O_MDLNO    ,");
		sql.append("NVL(HS_CD      ,'') AS HS_CD      ,");
		sql.append("NVL(ACC_CAT    ,'') AS ACC_CAT    ,");
		sql.append("NVL(OVS_CAT    ,'') AS OVS_CAT    ,");
		sql.append("NVL(AVD_ID     ,'') AS AVD_ID     ,");
		sql.append("NVL(R_QTY_ID   ,'') AS R_QTY_ID   ,");
		sql.append("NVL(M_ACC_QTY  ,'') AS M_ACC_QTY  ,");
		sql.append("NVL(DEC_P      ,'') AS DEC_P      ,");
		sql.append("NVL(UNIT_CD    ,'') AS UNIT_CD    ,");
		sql.append("NVL(IND_MDLNO  ,'') AS IND_MDLNO  ,");
		sql.append("NVL(KIT_ID     ,'') AS KIT_ID     ,");
		sql.append("NVL(CCM_ID     ,'') AS CCM_ID     ,");
		sql.append("NVL(CMDY_NM    ,'') AS CMDY_NM    ,");
		sql.append("NVL(DEPT       ,'') AS DEPT       ,");
		sql.append("NVL(NM         ,'') AS NM         ,");
		sql.append("NVL(PTNR_CD    ,'') AS PTNR_CD ");
		sql.append("FROM ");
		sql.append("PMDLNO ");
		sql.append("WHERE ");
		sql.append("MDLNO "+((getString("IMDLNO").equals(""))?" is null ":"=")+getString("IMDLNO")+" ");
		sql.append("AND ");
		sql.append("SUP_CD "+((getString("SUP_CD").equals(""))?" is null ":"=")+getString("SUP_CD")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_INTIC0202(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("SELECT ");
		sql.append("NVL(ITM_NO,        '') AS ITM_NO,");
		sql.append("NVL(APL_BDT,       '') AS APL_BDT,");
		sql.append("NVL(APL_EDT,       '') AS APL_EDT,");
		sql.append("NVL(GNR_ADM_NO,    '') AS GNR_ADM_NO,");
		sql.append("NVL(SCSN_ITM_NO,   '') AS SCSN_ITM_NO,");
		sql.append("NVL(QTY_NSUM_TYP,  '') AS QTY_NSUM_TYP,");
		sql.append("NVL(CSLD_ITM_NO,   '') AS CSLD_ITM_NO,");
		sql.append("NVL(RGS_DTTM,      '') AS RGS_DTTM,");
		sql.append("NVL(RGS_USR_CD,    '') AS RGS_USR_CD,");
		sql.append("NVL(UPD_DTTM,      '') AS UPD_DTTM,");
		sql.append("NVL(UPD_USR_CD,    '') AS UPD_USR_CD,");
		sql.append("NVL(LC_RGS_DTTM,   '') AS LC_RGS_DTTM,");
		sql.append("NVL(LCL_UPD_DTTM,  '') AS LCL_UPD_DTTM,");
		sql.append("NVL(FNL_UPD_PGM_ID,'') AS FNL_UPD_PGM_ID,");
		sql.append("NVL(DEL_TYP,   	'') AS DEL_TYP ");
		sql.append("FROM ");
		sql.append("INTIC ");
		sql.append("WHERE ");
		sql.append("ITM_NO	"+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND ");
		sql.append("APL_BDT	<"+((getString("NOW").equals(""))?" is null ":"=")+getString("NOW")+" ");
		sql.append("AND ");
		sql.append("APL_EDT >"+((getString("NOW").equals(""))?" is null ":"=")+getString("NOW")+" ");
		sql.append("ORDER BY GNR_ADM_NO DESC");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_M019909(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("SELECT ");
		sql.append("NVL(TRPT_CLSS_D_TYP,'') AS TRPT_CLSS_D_TYP ");
		sql.append("FROM ");
		sql.append("M01 ");
		sql.append("WHERE ");
		sql.append("VDR_CD "+((getString("VDR_CD").equals(""))?" is null ":"=")+getString("VDR_CD")+" ");
		sql.append("AND  ");
		sql.append("FM_TYP <> "+getString("FM_TYP1")+" ");
		sql.append("AND ");
		sql.append("FM_TYP <> "+getString("FM_TYP2")+" ");
		sql.append("AND ");
		sql.append("APL_BDT <"+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public int UPDATE_M029901(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("	UPDATE M02");
		sql.append("	SET");
		sql.append("	APL_EDT "+((getString("APL_EDT").equals(""))?" is null ":"=")+getString("APL_EDT")+",");
		sql.append("	UPD_DTTM = TO_DATE("+getString("UPD_DTTM")+",'YYYYMMDDHH24MISS'),               ");
		sql.append("    UPD_CHRG_CD "+((getString("UPD_CHRG_CD").equals(""))?" is null ":"=")+getString("UPD_CHRG_CD")+",        ");
		sql.append("    UPD_PGID "+((getString("UPD_PGID").equals(""))?" is null ":"=")+getString("UPD_PGID")+",");
		sql.append("	FM_TYP "+((getString("FM_TYP").equals(""))?" is null ":"=")+getString("FM_TYP")+"");
		sql.append("	WHERE ");
		sql.append("		   ODR_DVSN_CD  "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+"");
		sql.append("		   AND");
		sql.append("		   ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"  ");
		sql.append("		   AND");
		sql.append("		   APL_BDT <"+((getString("SYSDATE").equals(""))?" is null ":"=")+getString("SYSDATE")+"");
		sql.append("		   AND");
		sql.append("		   APL_EDT >"+((getString("SYSDATE").equals(""))?" is null ":"=")+getString("SYSDATE")+"");
		sql.append("		   AND FM_TYP <> "+getString("NOT_FM_TYP")+"");
		sql.append("	");
		sql.append("	   ");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int UPDATE_M029902(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("UPDATE ");
		sql.append("M02 ");
		sql.append("SET ");
		sql.append("APL_EDT			"+((getString("APL_EDT").equals(""))?" is null ":"=")+getString("APL_EDT")+",");
		sql.append("TMP_AC_TYP      "+((getString("TMP_AC_TYP").equals(""))?" is null ":"=")+getString("TMP_AC_TYP")+",");
		sql.append("SCSN_ITM_NO		"+((getString("SCSN_ITM_NO").equals(""))?" is null ":"=")+getString("SCSN_ITM_NO")+",");
		sql.append("QTY_NSUM_TYP	"+((getString("QTY_NSUM_TYP").equals(""))?" is null ":"=")+getString("QTY_NSUM_TYP")+",");
		sql.append("CSLD_ITM_NO		"+((getString("CSLD_ITM_NO").equals(""))?" is null ":"=")+getString("CSLD_ITM_NO")+",");
		sql.append("CTRL_DVSN_CD	"+((getString("CTRL_DVSN_CD").equals(""))?" is null ":"=")+getString("CTRL_DVSN_CD")+",");
		sql.append("MFCC_CD			"+((getString("MFCC_CD").equals(""))?" is null ":"=")+getString("MFCC_CD")+",");
		sql.append("PRNT_DVSN_CD	"+((getString("PRNT_DVSN_CD").equals(""))?" is null ":"=")+getString("PRNT_DVSN_CD")+",");
		sql.append("DSP_SPCF_CTNT	"+((getString("DSP_SPCF_CTNT").equals(""))?" is null ":"=")+getString("DSP_SPCF_CTNT")+",");
		sql.append("IBO_CAT_CD		"+((getString("IBO_CAT_CD").equals(""))?" is null ":"=")+getString("IBO_CAT_CD")+",");
		sql.append("FMCC_DPT_NM		"+((getString("FMCC_DPT_NM").equals(""))?" is null ":"=")+getString("FMCC_DPT_NM")+",");
		sql.append("FMCC_CHRG_NM	"+((getString("FMCC_CHRG_NM").equals(""))?" is null ":"=")+getString("FMCC_CHRG_NM")+",");
		sql.append("PRV_ITM_NO		"+((getString("PRV_ITM_NO").equals(""))?" is null ":"=")+getString("PRV_ITM_NO")+",");
		sql.append("CLR_CD			"+((getString("CLR_CD").equals(""))?" is null ":"=")+getString("CLR_CD")+",");
		sql.append("BRND_CD			"+((getString("BRND_CD").equals(""))?" is null ":"=")+getString("BRND_CD")+",");
		sql.append("HS_CD			"+((getString("HS_CD").equals(""))?" is null ":"=")+getString("HS_CD")+",");
		sql.append("ACC_CAT_CD		"+((getString("ACC_CAT_CD").equals(""))?" is null ":"=")+getString("ACC_CAT_CD")+",");
		sql.append("ITM_NM_ENG		"+((getString("ITM_NM_ENG").equals(""))?" is null ":"=")+getString("ITM_NM_ENG")+",");
		sql.append("SLS_QTY_UN_CD	"+((getString("SLS_QTY_UN_CD").equals(""))?" is null ":"=")+getString("SLS_QTY_UN_CD")+",");
		sql.append("SLC_PRMT_ITM_TYP"+((getString("SLC_PRMT_ITM_TYP").equals(""))?" is null ":"=")+getString("SLC_PRMT_ITM_TYP")+",");
		sql.append("KIT_TYP			"+((getString("KIT_TYP").equals(""))?" is null ":"=")+getString("KIT_TYP")+",");
		sql.append("GFT_TYP			"+((getString("GFT_TYP").equals(""))?" is null ":"=")+getString("GFT_TYP")+",");
		sql.append("FOC_TYP			"+((getString("FOC_TYP").equals(""))?" is null ":"=")+getString("FOC_TYP")+",");
		sql.append("MIN_ODR_QTY		"+((getString("MIN_ODR_QTY").equals(""))?" is null ":"=")+getString("MIN_ODR_QTY")+",");
		sql.append("STD_PKG_SZ		"+((getString("STD_PKG_SZ").equals(""))?" is null ":"=")+getString("STD_PKG_SZ")+",");
		sql.append("STD_PKG_WDTH	"+((getString("STD_PKG_WDTH").equals(""))?" is null ":"=")+getString("STD_PKG_WDTH")+",");
		sql.append("STD_PKG_HI		"+((getString("STD_PKG_HI").equals(""))?" is null ":"=")+getString("STD_PKG_HI")+",");
		sql.append("STD_PKG_WGT		"+((getString("STD_PKG_WGT").equals(""))?" is null ":"=")+getString("STD_PKG_WGT")+",");
		sql.append("TMP_PRIZ_TYP	"+((getString("TMP_PRIZ_TYP").equals(""))?" is null ":"=")+getString("TMP_PRIZ_TYP")+",");
		sql.append("STD_UP			"+((getString("STD_UP").equals(""))?" is null ":"=")+getString("STD_UP")+",");
		sql.append("ITM_NM_CN		"+((getString("ITM_NM_CN").equals(""))?" is null ":"=")+getString("ITM_NM_CN")+",");
		sql.append("SLS_ROUT_TYP	"+((getString("SLS_ROUT_TYP").equals(""))?" is null ":"=")+getString("SLS_ROUT_TYP")+",");
		sql.append("ITM_NET_WGT		"+((getString("ITM_NET_WGT").equals(""))?" is null ":"=")+getString("ITM_NET_WGT")+",");
		sql.append("UPD_DTTM		=TO_DATE("+getString("UPD_DTTM")+",'YYYYMMDD HH24:MI:SS'),");
		sql.append("UPD_CHRG_CD		"+((getString("UPD_CHRG_CD").equals(""))?" is null ":"=")+getString("UPD_CHRG_CD")+",");
		sql.append("UPD_PGID		"+((getString("UPD_PGID").equals(""))?" is null ":"=")+getString("UPD_PGID")+",");
		sql.append("FM_TYP			"+((getString("FM_TYP").equals(""))?" is null ":"=")+getString("FM_TYP")+" ");
		sql.append("WHERE ");
		sql.append("ITM_NO			"+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND ");
		sql.append("ODR_DVSN_CD		"+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+" ");
		sql.append("AND ");
		sql.append("APL_BDT			"+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+" ");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int 	UPDATE_M029903(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("	UPDATE M02");
		sql.append("	SET");
		sql.append("	APL_EDT "+((getString("APL_EDT").equals(""))?" is null ":"=")+getString("APL_EDT")+",");
		sql.append("	UPD_DTTM = TO_DATE("+getString("UPD_DTTM")+",'YYYYMMDDHH24MISS'),               ");
		sql.append("    UPD_CHRG_CD "+((getString("UPD_CHRG_CD").equals(""))?" is null ":"=")+getString("UPD_CHRG_CD")+",        ");
		sql.append("    UPD_PGID "+((getString("UPD_PGID").equals(""))?" is null ":"=")+getString("UPD_PGID")+",");
		sql.append("	FM_TYP "+((getString("FM_TYP").equals(""))?" is null ":"=")+getString("FM_TYP")+"");
		sql.append("	WHERE");
		sql.append("	ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+"");
		sql.append("	AND");
		sql.append("    ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("    AND");
		sql.append("    APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int UPDATE_M029904(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("UPDATE ");
		sql.append("M02 ");
		sql.append("SET ");
		sql.append("APL_EDT			"+((getString("APL_EDT").equals(""))?" is null ":"=")+getString("APL_EDT")+",");
		sql.append("UPD_DTTM		=TO_DATE("+getString("UPD_DTTM")+",'YYYYMMDD HH24:MI:SS'),");
		sql.append("UPD_CHRG_CD		"+((getString("UPD_CHRG_CD").equals(""))?" is null ":"=")+getString("UPD_CHRG_CD")+",");
		sql.append("UPD_PGID		"+((getString("UPD_PGID").equals(""))?" is null ":"=")+getString("UPD_PGID")+",");
		sql.append("FM_TYP			"+((getString("FM_TYP").equals(""))?" is null ":"=")+getString("FM_TYP")+" ");
		sql.append("WHERE ");
		sql.append("ITM_NO			"+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND ");
		sql.append("ODR_DVSN_CD		"+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+" ");
		sql.append("AND ");
		sql.append("APL_BDT			"+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+" ");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int UPDATE_M029905(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("UPDATE ");
		sql.append("M02 ");
		sql.append("SET ");
		sql.append("UPD_DTTM		=TO_DATE("+getString("UPD_DTTM")+",'YYYYMMDD HH24:MI:SS'),");
		sql.append("UPD_CHRG_CD		"+((getString("UPD_CHRG_CD").equals(""))?" is null ":"=")+getString("UPD_CHRG_CD")+",");
		sql.append("UPD_PGID		"+((getString("UPD_PGID").equals(""))?" is null ":"=")+getString("UPD_PGID")+",");
		sql.append("FM_TYP			"+((getString("FM_TYP").equals(""))?" is null ":"=")+getString("FM_TYP")+" ");
		sql.append("WHERE ");
		sql.append("ITM_NO			"+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND ");
		sql.append("ODR_DVSN_CD		"+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+" ");
		sql.append("AND ");
		sql.append("APL_BDT			"+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int UPDATE_M029906(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("	UPDATE M02");
		sql.append("	SET");
		sql.append("	GNR_ADM_NO "+((getString("GNR_ADM_NO").equals(""))?" is null ":"=")+getString("GNR_ADM_NO")+",");
		sql.append("	UPD_DTTM = TO_DATE("+getString("UPD_DTTM")+",'YYYYMMDDHH24MISS'),               ");
		sql.append("    UPD_CHRG_CD "+((getString("UPD_CHRG_CD").equals(""))?" is null ":"=")+getString("UPD_CHRG_CD")+",        ");
		sql.append("    UPD_PGID "+((getString("UPD_PGID").equals(""))?" is null ":"=")+getString("UPD_PGID")+",");
		sql.append("	FM_TYP "+((getString("FM_TYP").equals(""))?" is null ":"=")+getString("FM_TYP")+"");
		sql.append("	WHERE ");
		sql.append("		   ODR_DVSN_CD  "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+"");
		sql.append("		   AND");
		sql.append("		   ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"  ");
		sql.append("		   AND");
		sql.append("		   APL_BDT = (");
		sql.append("		   	SELECT");
		sql.append("			MAX(APL_BDT) AS APL_BDT");
		sql.append("			FROM");
		sql.append("			M02");
		sql.append("			WHERE ");
		sql.append("			ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+"");
		sql.append("			AND");
		sql.append("			ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("			AND");
		sql.append("			APL_EDT < "+getString("SYSDATE")+"");
		sql.append("			AND");
		sql.append("			FM_TYP <> "+getString("NOT_FM_TYP")+") ");
		sql.append("			");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int UPDATE_M029907(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("	UPDATE M02");
		sql.append("	SET");
		sql.append("	APL_EDT "+((getString("APL_EDT").equals(""))?" is null ":"=")+getString("APL_EDT")+",");
		sql.append("	GNR_ADM_NO "+((getString("GNR_ADM_NO").equals(""))?" is null ":"=")+getString("GNR_ADM_NO")+", ");
		sql.append("	UPD_DTTM = TO_DATE("+getString("UPD_DTTM")+",'YYYYMMDDHH24MISS'),               ");
		sql.append("    UPD_CHRG_CD "+((getString("UPD_CHRG_CD").equals(""))?" is null ":"=")+getString("UPD_CHRG_CD")+",        ");
		sql.append("    UPD_PGID "+((getString("UPD_PGID").equals(""))?" is null ":"=")+getString("UPD_PGID")+",");
		sql.append("	FM_TYP "+((getString("FM_TYP").equals(""))?" is null ":"=")+getString("FM_TYP")+"");
		sql.append("	WHERE ");
		sql.append("		   ODR_DVSN_CD  "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+" ");
		sql.append("		   AND");
		sql.append("		   ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"  ");
		sql.append("		   AND");
		sql.append("		   APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int UPDATE_M029908(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("UPDATE M02 ");
		sql.append("SET ");
		sql.append("APL_BDT 		"+((getString("NEW_APL_BDT").equals(""))?" is null ":"=")+getString("NEW_APL_BDT")+",");
		sql.append("TMP_AC_TYP      "+((getString("TMP_AC_TYP").equals(""))?" is null ":"=")+getString("TMP_AC_TYP")+",");
		sql.append("SCSN_ITM_NO		"+((getString("SCSN_ITM_NO").equals(""))?" is null ":"=")+getString("SCSN_ITM_NO")+",");
		sql.append("QTY_NSUM_TYP	"+((getString("QTY_NSUM_TYP").equals(""))?" is null ":"=")+getString("QTY_NSUM_TYP")+",");
		sql.append("CSLD_ITM_NO		"+((getString("CSLD_ITM_NO").equals(""))?" is null ":"=")+getString("CSLD_ITM_NO")+",");
		sql.append("CTRL_DVSN_CD	"+((getString("CTRL_DVSN_CD").equals(""))?" is null ":"=")+getString("CTRL_DVSN_CD")+",");
		sql.append("MFCC_CD			"+((getString("MFCC_CD").equals(""))?" is null ":"=")+getString("MFCC_CD")+",");
		sql.append("PRNT_DVSN_CD	"+((getString("PRNT_DVSN_CD").equals(""))?" is null ":"=")+getString("PRNT_DVSN_CD")+",");
		sql.append("DSP_SPCF_CTNT	"+((getString("DSP_SPCF_CTNT").equals(""))?" is null ":"=")+getString("DSP_SPCF_CTNT")+",");
		sql.append("IBO_CAT_CD		"+((getString("IBO_CAT_CD").equals(""))?" is null ":"=")+getString("IBO_CAT_CD")+",");
		sql.append("FMCC_DPT_NM		"+((getString("FMCC_DPT_NM").equals(""))?" is null ":"=")+getString("FMCC_DPT_NM")+",");
		sql.append("FMCC_CHRG_NM	"+((getString("FMCC_CHRG_NM").equals(""))?" is null ":"=")+getString("FMCC_CHRG_NM")+",");
		sql.append("PRV_ITM_NO		"+((getString("PRV_ITM_NO").equals(""))?" is null ":"=")+getString("PRV_ITM_NO")+",");
		sql.append("CLR_CD			"+((getString("CLR_CD").equals(""))?" is null ":"=")+getString("CLR_CD")+",");
		sql.append("BRND_CD			"+((getString("BRND_CD").equals(""))?" is null ":"=")+getString("BRND_CD")+",");
		sql.append("HS_CD			"+((getString("HS_CD").equals(""))?" is null ":"=")+getString("HS_CD")+",");
		sql.append("ACC_CAT_CD		"+((getString("ACC_CAT_CD").equals(""))?" is null ":"=")+getString("ACC_CAT_CD")+",");
		sql.append("ITM_NM_ENG		"+((getString("ITM_NM_ENG").equals(""))?" is null ":"=")+getString("ITM_NM_ENG")+",");
		sql.append("SLS_QTY_UN_CD	"+((getString("SLS_QTY_UN_CD").equals(""))?" is null ":"=")+getString("SLS_QTY_UN_CD")+",");
		sql.append("SLC_PRMT_ITM_TYP"+((getString("SLC_PRMT_ITM_TYP").equals(""))?" is null ":"=")+getString("SLC_PRMT_ITM_TYP")+",");
		sql.append("KIT_TYP			"+((getString("KIT_TYP").equals(""))?" is null ":"=")+getString("KIT_TYP")+",");
		sql.append("GFT_TYP			"+((getString("GFT_TYP").equals(""))?" is null ":"=")+getString("GFT_TYP")+",");
		sql.append("FOC_TYP			"+((getString("FOC_TYP").equals(""))?" is null ":"=")+getString("FOC_TYP")+",");
		sql.append("MIN_ODR_QTY		"+((getString("MIN_ODR_QTY").equals(""))?" is null ":"=")+getString("MIN_ODR_QTY")+",");
		sql.append("STD_PKG_SZ		"+((getString("STD_PKG_SZ").equals(""))?" is null ":"=")+getString("STD_PKG_SZ")+",");
		sql.append("STD_PKG_WDTH	"+((getString("STD_PKG_WDTH").equals(""))?" is null ":"=")+getString("STD_PKG_WDTH")+",");
		sql.append("STD_PKG_HI		"+((getString("STD_PKG_HI").equals(""))?" is null ":"=")+getString("STD_PKG_HI")+",");
		sql.append("STD_PKG_WGT		"+((getString("STD_PKG_WGT").equals(""))?" is null ":"=")+getString("STD_PKG_WGT")+",");
		sql.append("TMP_PRIZ_TYP	"+((getString("TMP_PRIZ_TYP").equals(""))?" is null ":"=")+getString("TMP_PRIZ_TYP")+",");
		sql.append("STD_UP			"+((getString("STD_UP").equals(""))?" is null ":"=")+getString("STD_UP")+",");
		sql.append("ITM_NM_CN		"+((getString("ITM_NM_CN").equals(""))?" is null ":"=")+getString("ITM_NM_CN")+",");
		sql.append("SLS_ROUT_TYP	"+((getString("SLS_ROUT_TYP").equals(""))?" is null ":"=")+getString("SLS_ROUT_TYP")+",");
		sql.append("ITM_NET_WGT		"+((getString("ITM_NET_WGT").equals(""))?" is null ":"=")+getString("ITM_NET_WGT")+",");
		sql.append("UPD_DTTM		=TO_DATE("+getString("UPD_DTTM")+",'YYYYMMDD HH24:MI:SS'),");
		sql.append("UPD_CHRG_CD		"+((getString("UPD_CHRG_CD").equals(""))?" is null ":"=")+getString("UPD_CHRG_CD")+",");
		sql.append("UPD_PGID		"+((getString("UPD_PGID").equals(""))?" is null ":"=")+getString("UPD_PGID")+",");
		sql.append("FM_TYP			"+((getString("FM_TYP").equals(""))?" is null ":"=")+getString("FM_TYP")+" ");
		sql.append("WHERE ");
		sql.append("ODR_DVSN_CD  "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+" ");
		sql.append("AND ");
		sql.append("ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND ");
		sql.append("APL_BDT "+((getString("OLD_APL_BDT").equals(""))?" is null ":"=")+getString("OLD_APL_BDT")+" ");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int DELETE_M029901(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("DELETE ");
		sql.append("FROM ");
		sql.append("M02 ");
		sql.append("WHERE ");
		sql.append("ITM_NO		"+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND ");
		sql.append("ODR_DVSN_CD	"+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+" ");
		sql.append("AND ");
		sql.append("FM_TYP		"+((getString("FM_TYP").equals(""))?" is null ":"=")+getString("FM_TYP")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int DELETE_M029902(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("	DELETE FROM M02");
		sql.append("	WHERE");
		sql.append("	ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+"");
		sql.append("	AND");
		sql.append("	ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("	AND");
		sql.append("	APL_BDT = (");
		sql.append("	SELECT");
		sql.append("	MIN(APL_BDT) AS APL_BDT");
		sql.append("	FROM");
		sql.append("	M02");
		sql.append("	WHERE ");
		sql.append("	ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+"");
		sql.append("	AND");
		sql.append("	ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("	AND");
		sql.append("	FM_TYP <> "+getString("NOT_FM_TYP")+") ");
		sql.append("	");
		sql.append("	");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int INSERT_BM029901(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("INSERT INTO BM02(");
		sql.append("SEQ_NO ,");
		sql.append("ITM_NO ,");
		sql.append("ODR_DVSN_CD ,");
		sql.append("APL_BDT ,");
		sql.append("APL_EDT ,");
		sql.append("GNR_ADM_NO ,");
		sql.append("TMP_AC_TYP ,");
		sql.append("SCSN_ITM_NO ,");
		sql.append("QTY_NSUM_TYP ,");
		sql.append("CSLD_ITM_NO ,");
		sql.append("CTRL_DVSN_CD ,");
		sql.append("MFCC_CD ,");
		sql.append("PRNT_DVSN_CD ,");
		sql.append("DSP_SPCF_CTNT ,");
		sql.append("IBO_CAT_CD ,");
		sql.append("FMCC_DPT_NM ,");
		sql.append("FMCC_CHRG_NM ,");
		sql.append("PRV_ITM_NO ,");
		sql.append("CLR_CD ,");
		sql.append("BRND_CD ,");
		sql.append("HS_CD ,");
		sql.append("ACC_CAT_CD ,");
		sql.append("SLS_QTY_UN_CD ,");
		sql.append("SLC_PRMT_ITM_TYP ,");
		sql.append("ITM_NM_ENG ,");
		sql.append("KIT_TYP ,");
		sql.append("GFT_TYP ,");
		sql.append("FOC_TYP ,");
		sql.append("MIN_ODR_QTY ,");
		sql.append("STD_PKG_SZ ,");
		sql.append("STD_PKG_WDTH ,");
		sql.append("STD_PKG_HI ,");
		sql.append("STD_PKG_WGT ,");
		sql.append("TMP_PRIZ_TYP ,");
		sql.append("STD_UP ,");
		sql.append("ITM_NM_CN ,");
		sql.append("SLS_ROUT_TYP ,");
		sql.append("ITM_NET_WGT	,");
		sql.append("FM_TYP ,");
		sql.append("RGS_DTTM ,");
		sql.append("RGS_CHRG_CD ,");
		sql.append("RGS_PGID ,");
		sql.append("UPD_DTTM ,");
		sql.append("UPD_CHRG_CD ,");
		sql.append("UPD_PGID");
		sql.append(") ");
		sql.append("SELECT SEQ_BM02.NEXTVAL,");
		sql.append("ITM_NO ,");
		sql.append("ODR_DVSN_CD ,");
		sql.append("APL_BDT ,");
		sql.append("APL_EDT ,");
		sql.append("GNR_ADM_NO ,");
		sql.append("TMP_AC_TYP ,");
		sql.append("SCSN_ITM_NO ,");
		sql.append("QTY_NSUM_TYP ,");
		sql.append("CSLD_ITM_NO ,");
		sql.append("CTRL_DVSN_CD ,");
		sql.append("MFCC_CD ,");
		sql.append("PRNT_DVSN_CD ,");
		sql.append("DSP_SPCF_CTNT ,");
		sql.append("IBO_CAT_CD ,");
		sql.append("FMCC_DPT_NM ,");
		sql.append("FMCC_CHRG_NM ,");
		sql.append("PRV_ITM_NO ,");
		sql.append("CLR_CD ,");
		sql.append("BRND_CD ,");
		sql.append("HS_CD ,");
		sql.append("ACC_CAT_CD ,");
		sql.append("SLS_QTY_UN_CD ,");
		sql.append("SLC_PRMT_ITM_TYP ,");
		sql.append("ITM_NM_ENG ,");
		sql.append("KIT_TYP ,");
		sql.append("GFT_TYP ,");
		sql.append("FOC_TYP ,");
		sql.append("MIN_ODR_QTY ,");
		sql.append("STD_PKG_SZ ,");
		sql.append("STD_PKG_WDTH ,");
		sql.append("STD_PKG_HI ,");
		sql.append("STD_PKG_WGT ,");
		sql.append("TMP_PRIZ_TYP ,");
		sql.append("STD_UP ,");
		sql.append("ITM_NM_CN ,");
		sql.append("SLS_ROUT_TYP ,");
		sql.append("ITM_NET_WGT	,");
		sql.append("FM_TYP ,");
		sql.append("RGS_DTTM ,");
		sql.append("RGS_CHRG_CD ,");
		sql.append("RGS_PGID ,");
		sql.append("UPD_DTTM ,");
		sql.append("UPD_CHRG_CD ,");
		sql.append("UPD_PGID ");
		sql.append("FROM M02 ");
		sql.append("WHERE ");
		sql.append("ITM_NO			"+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND                     ");
		sql.append("ODR_DVSN_CD		"+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+" ");
		sql.append("AND                     ");
		sql.append("APL_BDT			=	"+getString("APL_BDT")+" ");
		sql.append("	");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int INSERT_BM029902(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("INSERT INTO BM02(");
		sql.append("SEQ_NO ,");
		sql.append("ITM_NO ,");
		sql.append("ODR_DVSN_CD ,");
		sql.append("APL_BDT ,");
		sql.append("APL_EDT ,");
		sql.append("GNR_ADM_NO ,");
		sql.append("TMP_AC_TYP ,");
		sql.append("SCSN_ITM_NO ,");
		sql.append("QTY_NSUM_TYP ,");
		sql.append("CSLD_ITM_NO ,");
		sql.append("CTRL_DVSN_CD ,");
		sql.append("MFCC_CD ,");
		sql.append("PRNT_DVSN_CD ,");
		sql.append("DSP_SPCF_CTNT ,");
		sql.append("IBO_CAT_CD ,");
		sql.append("FMCC_DPT_NM ,");
		sql.append("FMCC_CHRG_NM ,");
		sql.append("PRV_ITM_NO ,");
		sql.append("CLR_CD ,");
		sql.append("BRND_CD ,");
		sql.append("HS_CD ,");
		sql.append("ACC_CAT_CD ,");
		sql.append("SLS_QTY_UN_CD ,");
		sql.append("SLC_PRMT_ITM_TYP ,");
		sql.append("ITM_NM_ENG ,");
		sql.append("KIT_TYP ,");
		sql.append("GFT_TYP ,");
		sql.append("FOC_TYP ,");
		sql.append("MIN_ODR_QTY ,");
		sql.append("STD_PKG_SZ ,");
		sql.append("STD_PKG_WDTH ,");
		sql.append("STD_PKG_HI ,");
		sql.append("STD_PKG_WGT ,");
		sql.append("TMP_PRIZ_TYP ,");
		sql.append("STD_UP ,");
		sql.append("ITM_NM_CN ,");
		sql.append("SLS_ROUT_TYP ,");
		sql.append("ITM_NET_WGT	,");
		sql.append("FM_TYP ,");
		sql.append("RGS_DTTM ,");
		sql.append("RGS_CHRG_CD ,");
		sql.append("RGS_PGID ,");
		sql.append("UPD_DTTM ,");
		sql.append("UPD_CHRG_CD ,");
		sql.append("UPD_PGID");
		sql.append(") ");
		sql.append("SELECT SEQ_BM02.NEXTVAL,");
		sql.append("ITM_NO ,");
		sql.append("ODR_DVSN_CD ,");
		sql.append("APL_BDT ,");
		sql.append("APL_EDT ,");
		sql.append("GNR_ADM_NO ,");
		sql.append("TMP_AC_TYP ,");
		sql.append("SCSN_ITM_NO ,");
		sql.append("QTY_NSUM_TYP ,");
		sql.append("CSLD_ITM_NO ,");
		sql.append("CTRL_DVSN_CD ,");
		sql.append("MFCC_CD ,");
		sql.append("PRNT_DVSN_CD ,");
		sql.append("DSP_SPCF_CTNT ,");
		sql.append("IBO_CAT_CD ,");
		sql.append("FMCC_DPT_NM ,");
		sql.append("FMCC_CHRG_NM ,");
		sql.append("PRV_ITM_NO ,");
		sql.append("CLR_CD ,");
		sql.append("BRND_CD ,");
		sql.append("HS_CD ,");
		sql.append("ACC_CAT_CD ,");
		sql.append("SLS_QTY_UN_CD ,");
		sql.append("SLC_PRMT_ITM_TYP ,");
		sql.append("ITM_NM_ENG ,");
		sql.append("KIT_TYP ,");
		sql.append("GFT_TYP ,");
		sql.append("FOC_TYP ,");
		sql.append("MIN_ODR_QTY ,");
		sql.append("STD_PKG_SZ ,");
		sql.append("STD_PKG_WDTH ,");
		sql.append("STD_PKG_HI ,");
		sql.append("STD_PKG_WGT ,");
		sql.append("TMP_PRIZ_TYP ,");
		sql.append("STD_UP ,");
		sql.append("ITM_NM_CN ,");
		sql.append("SLS_ROUT_TYP ,");
		sql.append("ITM_NET_WGT	,");
		sql.append("FM_TYP ,");
		sql.append("RGS_DTTM ,");
		sql.append("RGS_CHRG_CD ,");
		sql.append("RGS_PGID ,");
		sql.append("UPD_DTTM ,");
		sql.append("UPD_CHRG_CD ,");
		sql.append("UPD_PGID ");
		sql.append("FROM M02 ");
		sql.append("WHERE ");
		sql.append("ITM_NO			"+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND                     ");
		sql.append("ODR_DVSN_CD		"+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+" ");
		sql.append("AND                     ");
		sql.append("APL_EDT >=	"+getString("NOWDATE")+" ");
		sql.append("AND ");
		sql.append("FM_TYP <> "+getString("NOT_FM_TYP")+"  ");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int INSERT_BM029903(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("INSERT INTO BM02(");
		sql.append("SEQ_NO ,");
		sql.append("ITM_NO ,");
		sql.append("ODR_DVSN_CD ,");
		sql.append("APL_BDT ,");
		sql.append("APL_EDT ,");
		sql.append("GNR_ADM_NO ,");
		sql.append("TMP_AC_TYP ,");
		sql.append("SCSN_ITM_NO ,");
		sql.append("QTY_NSUM_TYP ,");
		sql.append("CSLD_ITM_NO ,");
		sql.append("CTRL_DVSN_CD ,");
		sql.append("MFCC_CD ,");
		sql.append("PRNT_DVSN_CD ,");
		sql.append("DSP_SPCF_CTNT ,");
		sql.append("IBO_CAT_CD ,");
		sql.append("FMCC_DPT_NM ,");
		sql.append("FMCC_CHRG_NM ,");
		sql.append("PRV_ITM_NO ,");
		sql.append("CLR_CD ,");
		sql.append("BRND_CD ,");
		sql.append("HS_CD ,");
		sql.append("ACC_CAT_CD ,");
		sql.append("SLS_QTY_UN_CD ,");
		sql.append("SLC_PRMT_ITM_TYP ,");
		sql.append("ITM_NM_ENG ,");
		sql.append("KIT_TYP ,");
		sql.append("GFT_TYP ,");
		sql.append("FOC_TYP ,");
		sql.append("MIN_ODR_QTY ,");
		sql.append("STD_PKG_SZ ,");
		sql.append("STD_PKG_WDTH ,");
		sql.append("STD_PKG_HI ,");
		sql.append("STD_PKG_WGT ,");
		sql.append("TMP_PRIZ_TYP ,");
		sql.append("STD_UP ,");
		sql.append("ITM_NM_CN ,");
		sql.append("SLS_ROUT_TYP ,");
		sql.append("ITM_NET_WGT	,");
		sql.append("FM_TYP ,");
		sql.append("RGS_DTTM ,");
		sql.append("RGS_CHRG_CD ,");
		sql.append("RGS_PGID ,");
		sql.append("UPD_DTTM ,");
		sql.append("UPD_CHRG_CD ,");
		sql.append("UPD_PGID");
		sql.append(") ");
		sql.append("SELECT SEQ_BM02.NEXTVAL,");
		sql.append("ITM_NO ,");
		sql.append("ODR_DVSN_CD ,");
		sql.append("APL_BDT ,");
		sql.append("APL_EDT ,");
		sql.append("GNR_ADM_NO ,");
		sql.append("TMP_AC_TYP ,");
		sql.append("SCSN_ITM_NO ,");
		sql.append("QTY_NSUM_TYP ,");
		sql.append("CSLD_ITM_NO ,");
		sql.append("CTRL_DVSN_CD ,");
		sql.append("MFCC_CD ,");
		sql.append("PRNT_DVSN_CD ,");
		sql.append("DSP_SPCF_CTNT ,");
		sql.append("IBO_CAT_CD ,");
		sql.append("FMCC_DPT_NM ,");
		sql.append("FMCC_CHRG_NM ,");
		sql.append("PRV_ITM_NO ,");
		sql.append("CLR_CD ,");
		sql.append("BRND_CD ,");
		sql.append("HS_CD ,");
		sql.append("ACC_CAT_CD ,");
		sql.append("SLS_QTY_UN_CD ,");
		sql.append("SLC_PRMT_ITM_TYP ,");
		sql.append("ITM_NM_ENG ,");
		sql.append("KIT_TYP ,");
		sql.append("GFT_TYP ,");
		sql.append("FOC_TYP ,");
		sql.append("MIN_ODR_QTY ,");
		sql.append("STD_PKG_SZ ,");
		sql.append("STD_PKG_WDTH ,");
		sql.append("STD_PKG_HI ,");
		sql.append("STD_PKG_WGT ,");
		sql.append("TMP_PRIZ_TYP ,");
		sql.append("STD_UP ,");
		sql.append("ITM_NM_CN ,");
		sql.append("SLS_ROUT_TYP ,");
		sql.append("ITM_NET_WGT	,");
		sql.append("FM_TYP ,");
		sql.append("RGS_DTTM ,");
		sql.append("RGS_CHRG_CD ,");
		sql.append("RGS_PGID ,");
		sql.append("UPD_DTTM ,");
		sql.append("UPD_CHRG_CD ,");
		sql.append("UPD_PGID ");
		sql.append("FROM M02 ");
		sql.append("WHERE ");
		sql.append("ITM_NO			"+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND                     ");
		sql.append("ODR_DVSN_CD		"+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+" ");
		sql.append("AND                     ");
		sql.append("APL_EDT <=	"+getString("NOWDATE")+" ");
		sql.append("AND ");
		sql.append("FM_TYP <> "+getString("NOT_FM_TYP")+"  ");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int INSERT_BM029904(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("INSERT INTO BM02(");
		sql.append("SEQ_NO ,");
		sql.append("ITM_NO ,");
		sql.append("ODR_DVSN_CD ,");
		sql.append("APL_BDT ,");
		sql.append("APL_EDT ,");
		sql.append("GNR_ADM_NO ,");
		sql.append("TMP_AC_TYP ,");
		sql.append("SCSN_ITM_NO ,");
		sql.append("QTY_NSUM_TYP ,");
		sql.append("CSLD_ITM_NO ,");
		sql.append("CTRL_DVSN_CD ,");
		sql.append("MFCC_CD ,");
		sql.append("PRNT_DVSN_CD ,");
		sql.append("DSP_SPCF_CTNT ,");
		sql.append("IBO_CAT_CD ,");
		sql.append("FMCC_DPT_NM ,");
		sql.append("FMCC_CHRG_NM ,");
		sql.append("PRV_ITM_NO ,");
		sql.append("CLR_CD ,");
		sql.append("BRND_CD ,");
		sql.append("HS_CD ,");
		sql.append("ACC_CAT_CD ,");
		sql.append("SLS_QTY_UN_CD ,");
		sql.append("SLC_PRMT_ITM_TYP ,");
		sql.append("ITM_NM_ENG ,");
		sql.append("KIT_TYP ,");
		sql.append("GFT_TYP ,");
		sql.append("FOC_TYP ,");
		sql.append("MIN_ODR_QTY ,");
		sql.append("STD_PKG_SZ ,");
		sql.append("STD_PKG_WDTH ,");
		sql.append("STD_PKG_HI ,");
		sql.append("STD_PKG_WGT ,");
		sql.append("TMP_PRIZ_TYP ,");
		sql.append("STD_UP ,");
		sql.append("ITM_NM_CN ,");
		sql.append("SLS_ROUT_TYP ,");
		sql.append("ITM_NET_WGT	,");
		sql.append("FM_TYP ,");
		sql.append("RGS_DTTM ,");
		sql.append("RGS_CHRG_CD ,");
		sql.append("RGS_PGID ,");
		sql.append("UPD_DTTM ,");
		sql.append("UPD_CHRG_CD ,");
		sql.append("UPD_PGID");
		sql.append(") ");
		sql.append("SELECT SEQ_BM02.NEXTVAL,");
		sql.append("ITM_NO ,");
		sql.append("ODR_DVSN_CD ,");
		sql.append("APL_BDT ,");
		sql.append("APL_EDT ,");
		sql.append("GNR_ADM_NO ,");
		sql.append("TMP_AC_TYP ,");
		sql.append("SCSN_ITM_NO ,");
		sql.append("QTY_NSUM_TYP ,");
		sql.append("CSLD_ITM_NO ,");
		sql.append("CTRL_DVSN_CD ,");
		sql.append("MFCC_CD ,");
		sql.append("PRNT_DVSN_CD ,");
		sql.append("DSP_SPCF_CTNT ,");
		sql.append("IBO_CAT_CD ,");
		sql.append("FMCC_DPT_NM ,");
		sql.append("FMCC_CHRG_NM ,");
		sql.append("PRV_ITM_NO ,");
		sql.append("CLR_CD ,");
		sql.append("BRND_CD ,");
		sql.append("HS_CD ,");
		sql.append("ACC_CAT_CD ,");
		sql.append("SLS_QTY_UN_CD ,");
		sql.append("SLC_PRMT_ITM_TYP ,");
		sql.append("ITM_NM_ENG ,");
		sql.append("KIT_TYP ,");
		sql.append("GFT_TYP ,");
		sql.append("FOC_TYP ,");
		sql.append("MIN_ODR_QTY ,");
		sql.append("STD_PKG_SZ ,");
		sql.append("STD_PKG_WDTH ,");
		sql.append("STD_PKG_HI ,");
		sql.append("STD_PKG_WGT ,");
		sql.append("TMP_PRIZ_TYP ,");
		sql.append("STD_UP ,");
		sql.append("ITM_NM_CN ,");
		sql.append("SLS_ROUT_TYP ,");
		sql.append("ITM_NET_WGT	,");
		sql.append("FM_TYP ,");
		sql.append("RGS_DTTM ,");
		sql.append("RGS_CHRG_CD ,");
		sql.append("RGS_PGID ,");
		sql.append("UPD_DTTM ,");
		sql.append("UPD_CHRG_CD ,");
		sql.append("UPD_PGID ");
		sql.append("FROM M02 ");
		sql.append("WHERE ");
		sql.append("ITM_NO			"+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND                     ");
		sql.append("ODR_DVSN_CD		"+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+" ");
		sql.append("AND                     ");
		sql.append("FM_TYP			"+((getString("FM_TYP").equals(""))?" is null ":"=")+getString("FM_TYP")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public SelectResultRset SELECT_M0218(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("	SELECT");
		sql.append("	COUNT(*) AS COUNTS");
		sql.append("	FROM ");
		sql.append("	M02");
		sql.append("	WHERE");
		sql.append("	ITM_NO  "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("	AND");
		sql.append("	ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+"");
		sql.append("	AND ");
		sql.append("	APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		sql.append("	AND");
		sql.append("	TO_CHAR(NVL(UPD_DTTM,''),'YYYYMMDDHH24MISS') "+((getString("UPD_DTTM").equals(""))?" is null ":"=")+getString("UPD_DTTM")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}


	public void setITM_NO(String value){
		if(value==null) {
			paramsString.remove("ITM_NO");
			return;
		}
		paramsString.put("ITM_NO",value);
	}


	public void setODR_DVSN_CD(String value){
		if(value==null) {
			paramsString.remove("ODR_DVSN_CD");
			return;
		}
		paramsString.put("ODR_DVSN_CD",value);
	}


	public void setAPL_BDT(String value){
		if(value==null) {
			paramsString.remove("APL_BDT");
			return;
		}
		paramsString.put("APL_BDT",value);
	}


	public void setAPL_EDT(String value){
		if(value==null) {
			paramsString.remove("APL_EDT");
			return;
		}
		paramsString.put("APL_EDT",value);
	}


	public void setGNR_ADM_NO(String value){
		if(value==null) {
			paramsString.remove("GNR_ADM_NO");
			return;
		}
		paramsString.put("GNR_ADM_NO",value);
	}


	public void setTMP_AC_TYP(String value){
		if(value==null) {
			paramsString.remove("TMP_AC_TYP");
			return;
		}
		paramsString.put("TMP_AC_TYP",value);
	}


	public void setSCSN_ITM_NO(String value){
		if(value==null) {
			paramsString.remove("SCSN_ITM_NO");
			return;
		}
		paramsString.put("SCSN_ITM_NO",value);
	}


	public void setQTY_NSUM_TYP(String value){
		if(value==null) {
			paramsString.remove("QTY_NSUM_TYP");
			return;
		}
		paramsString.put("QTY_NSUM_TYP",value);
	}


	public void setCSLD_ITM_NO(String value){
		if(value==null) {
			paramsString.remove("CSLD_ITM_NO");
			return;
		}
		paramsString.put("CSLD_ITM_NO",value);
	}


	public void setCTRL_DVSN_CD(String value){
		if(value==null) {
			paramsString.remove("CTRL_DVSN_CD");
			return;
		}
		paramsString.put("CTRL_DVSN_CD",value);
	}


	public void setMFCC_CD(String value){
		if(value==null) {
			paramsString.remove("MFCC_CD");
			return;
		}
		paramsString.put("MFCC_CD",value);
	}


	public void setPRNT_DVSN_CD(String value){
		if(value==null) {
			paramsString.remove("PRNT_DVSN_CD");
			return;
		}
		paramsString.put("PRNT_DVSN_CD",value);
	}


	public void setDSP_SPCF_CTNT(String value){
		if(value==null) {
			paramsString.remove("DSP_SPCF_CTNT");
			return;
		}
		paramsString.put("DSP_SPCF_CTNT",value);
	}


	public void setIBO_CAT_CD(String value){
		if(value==null) {
			paramsString.remove("IBO_CAT_CD");
			return;
		}
		paramsString.put("IBO_CAT_CD",value);
	}


	public void setFMCC_DPT_NM(String value){
		if(value==null) {
			paramsString.remove("FMCC_DPT_NM");
			return;
		}
		paramsString.put("FMCC_DPT_NM",value);
	}


	public void setFMCC_CHRG_NM(String value){
		if(value==null) {
			paramsString.remove("FMCC_CHRG_NM");
			return;
		}
		paramsString.put("FMCC_CHRG_NM",value);
	}


	public void setPRV_ITM_NO(String value){
		if(value==null) {
			paramsString.remove("PRV_ITM_NO");
			return;
		}
		paramsString.put("PRV_ITM_NO",value);
	}


	public void setCLR_CD(String value){
		if(value==null) {
			paramsString.remove("CLR_CD");
			return;
		}
		paramsString.put("CLR_CD",value);
	}


	public void setBRND_CD(String value){
		if(value==null) {
			paramsString.remove("BRND_CD");
			return;
		}
		paramsString.put("BRND_CD",value);
	}


	public void setHS_CD(String value){
		if(value==null) {
			paramsString.remove("HS_CD");
			return;
		}
		paramsString.put("HS_CD",value);
	}


	public void setACC_CAT_CD(String value){
		if(value==null) {
			paramsString.remove("ACC_CAT_CD");
			return;
		}
		paramsString.put("ACC_CAT_CD",value);
	}


	public void setITM_NM_ENG(String value){
		if(value==null) {
			paramsString.remove("ITM_NM_ENG");
			return;
		}
		paramsString.put("ITM_NM_ENG",value);
	}


	public void setSLS_QTY_UN_CD(String value){
		if(value==null) {
			paramsString.remove("SLS_QTY_UN_CD");
			return;
		}
		paramsString.put("SLS_QTY_UN_CD",value);
	}


	public void setSLC_PRMT_ITM_TYP(String value){
		if(value==null) {
			paramsString.remove("SLC_PRMT_ITM_TYP");
			return;
		}
		paramsString.put("SLC_PRMT_ITM_TYP",value);
	}


	public void setKIT_TYP(String value){
		if(value==null) {
			paramsString.remove("KIT_TYP");
			return;
		}
		paramsString.put("KIT_TYP",value);
	}


	public void setGFT_TYP(String value){
		if(value==null) {
			paramsString.remove("GFT_TYP");
			return;
		}
		paramsString.put("GFT_TYP",value);
	}


	public void setFOC_TYP(String value){
		if(value==null) {
			paramsString.remove("FOC_TYP");
			return;
		}
		paramsString.put("FOC_TYP",value);
	}


	public void setTMP_PRIZ_TYP(String value){
		if(value==null) {
			paramsString.remove("TMP_PRIZ_TYP");
			return;
		}
		paramsString.put("TMP_PRIZ_TYP",value);
	}


	public void setITM_NM_CN(String value){
		if(value==null) {
			paramsString.remove("ITM_NM_CN");
			return;
		}
		paramsString.put("ITM_NM_CN",value);
	}


	public void setSLS_ROUT_TYP(String value){
		if(value==null) {
			paramsString.remove("SLS_ROUT_TYP");
			return;
		}
		paramsString.put("SLS_ROUT_TYP",value);
	}


	public void setRGS_DTTM(String value){
		if(value==null) {
			paramsString.remove("RGS_DTTM");
			return;
		}
		paramsString.put("RGS_DTTM",value);
	}


	public void setRGS_CHRG_CD(String value){
		if(value==null) {
			paramsString.remove("RGS_CHRG_CD");
			return;
		}
		paramsString.put("RGS_CHRG_CD",value);
	}


	public void setRGS_PGID(String value){
		if(value==null) {
			paramsString.remove("RGS_PGID");
			return;
		}
		paramsString.put("RGS_PGID",value);
	}


	public void setUPD_DTTM(String value){
		if(value==null) {
			paramsString.remove("UPD_DTTM");
			return;
		}
		paramsString.put("UPD_DTTM",value);
	}


	public void setUPD_CHRG_CD(String value){
		if(value==null) {
			paramsString.remove("UPD_CHRG_CD");
			return;
		}
		paramsString.put("UPD_CHRG_CD",value);
	}


	public void setUPD_PGID(String value){
		if(value==null) {
			paramsString.remove("UPD_PGID");
			return;
		}
		paramsString.put("UPD_PGID",value);
	}


	public void setFM_TYP(String value){
		if(value==null) {
			paramsString.remove("FM_TYP");
			return;
		}
		paramsString.put("FM_TYP",value);
	}


	public void setTEMP_APL(String value){
		if(value==null) {
			paramsString.remove("TEMP_APL");
			return;
		}
		paramsString.put("TEMP_APL",value);
	}


	public void setFM(String value){
		if(value==null) {
			paramsString.remove("FM");
			return;
		}
		paramsString.put("FM",value);
	}


	public void setTEMPDATE(String value){
		if(value==null) {
			paramsString.remove("TEMPDATE");
			return;
		}
		paramsString.put("TEMPDATE",value);
	}


	public void setFM9(String value){
		if(value==null) {
			paramsString.remove("FM9");
			return;
		}
		paramsString.put("FM9",value);
	}


	public void setFM6(String value){
		if(value==null) {
			paramsString.remove("FM6");
			return;
		}
		paramsString.put("FM6",value);
	}


	public void setDATE9999(String value){
		if(value==null) {
			paramsString.remove("DATE9999");
			return;
		}
		paramsString.put("DATE9999",value);
	}


	public void setFM8(String value){
		if(value==null) {
			paramsString.remove("FM8");
			return;
		}
		paramsString.put("FM8",value);
	}


	public void setENDDATE(String value){
		if(value==null) {
			paramsString.remove("ENDDATE");
			return;
		}
		paramsString.put("ENDDATE",value);
	}


	public void setMDLNO(String value){
		if(value==null) {
			paramsString.remove("MDLNO");
			return;
		}
		paramsString.put("MDLNO",value);
	}


	public void setSUP_CD(String value){
		if(value==null) {
			paramsString.remove("SUP_CD");
			return;
		}
		paramsString.put("SUP_CD",value);
	}


	public void setMIN_ODR_QTY(String value){
		if(value==null) {
			paramsString.remove("MIN_ODR_QTY");
			return;
		}
		paramsString.put("MIN_ODR_QTY",value);
	}


	public void setSTD_PKG_SZ(String value){
		if(value==null) {
			paramsString.remove("STD_PKG_SZ");
			return;
		}
		paramsString.put("STD_PKG_SZ",value);
	}


	public void setSTD_PKG_WDTH(String value){
		if(value==null) {
			paramsString.remove("STD_PKG_WDTH");
			return;
		}
		paramsString.put("STD_PKG_WDTH",value);
	}


	public void setSTD_PKG_HI(String value){
		if(value==null) {
			paramsString.remove("STD_PKG_HI");
			return;
		}
		paramsString.put("STD_PKG_HI",value);
	}


	public void setSTD_PKG_WGT(String value){
		if(value==null) {
			paramsString.remove("STD_PKG_WGT");
			return;
		}
		paramsString.put("STD_PKG_WGT",value);
	}


	public void setSTD_UP(String value){
		if(value==null) {
			paramsString.remove("STD_UP");
			return;
		}
		paramsString.put("STD_UP",value);
	}


	public void setITM_NET_WGT(String value){
		if(value==null) {
			paramsString.remove("ITM_NET_WGT");
			return;
		}
		paramsString.put("ITM_NET_WGT",value);
	}


	public void setNOT_FM_TYP(String value){
		if(value==null) {
			paramsString.remove("NOT_FM_TYP");
			return;
		}
		paramsString.put("NOT_FM_TYP",value);
	}


	public void setFM_TYP_9(String value){
		if(value==null) {
			paramsString.remove("FM_TYP_9");
			return;
		}
		paramsString.put("FM_TYP_9",value);
	}


	public void setFM_TYP_6(String value){
		if(value==null) {
			paramsString.remove("FM_TYP_6");
			return;
		}
		paramsString.put("FM_TYP_6",value);
	}


	public void setFM_TYP1(String value){
		if(value==null) {
			paramsString.remove("FM_TYP1");
			return;
		}
		paramsString.put("FM_TYP1",value);
	}


	public void setFM_TYP2(String value){
		if(value==null) {
			paramsString.remove("FM_TYP2");
			return;
		}
		paramsString.put("FM_TYP2",value);
	}


	public void setUNI_ITM_NO(String value){
		if(value==null) {
			paramsString.remove("UNI_ITM_NO");
			return;
		}
		paramsString.put("UNI_ITM_NO",value);
	}


	public void setnowDate(String value){
		if(value==null) {
			paramsString.remove("nowDate");
			return;
		}
		paramsString.put("nowDate",value);
	}


	public void setIMDLNO(String value){
		if(value==null) {
			paramsString.remove("IMDLNO");
			return;
		}
		paramsString.put("IMDLNO",value);
	}


	public void setNOW(String value){
		if(value==null) {
			paramsString.remove("NOW");
			return;
		}
		paramsString.put("NOW",value);
	}


	public void setVDR_CD(String value){
		if(value==null) {
			paramsString.remove("VDR_CD");
			return;
		}
		paramsString.put("VDR_CD",value);
	}


	public void setSYSDATE(String value){
		if(value==null) {
			paramsString.remove("SYSDATE");
			return;
		}
		paramsString.put("SYSDATE",value);
	}


	public void setNEW_APL_BDT(String value){
		if(value==null) {
			paramsString.remove("NEW_APL_BDT");
			return;
		}
		paramsString.put("NEW_APL_BDT",value);
	}


	public void setOLD_APL_BDT(String value){
		if(value==null) {
			paramsString.remove("OLD_APL_BDT");
			return;
		}
		paramsString.put("OLD_APL_BDT",value);
	}


	public void setNOWDATE(String value){
		if(value==null) {
			paramsString.remove("NOWDATE");
			return;
		}
		paramsString.put("NOWDATE",value);
	}


	public void setMIN_ODR_QTY(BigDecimal value){
		if(value==null) {
			paramsBigDecimal.remove("MIN_ODR_QTY");
			return;
		}
		paramsBigDecimal.put("MIN_ODR_QTY",value);
	}


	public void setSTD_PKG_SZ(BigDecimal value){
		if(value==null) {
			paramsBigDecimal.remove("STD_PKG_SZ");
			return;
		}
		paramsBigDecimal.put("STD_PKG_SZ",value);
	}


	public void setSTD_PKG_WDTH(BigDecimal value){
		if(value==null) {
			paramsBigDecimal.remove("STD_PKG_WDTH");
			return;
		}
		paramsBigDecimal.put("STD_PKG_WDTH",value);
	}


	public void setSTD_PKG_HI(BigDecimal value){
		if(value==null) {
			paramsBigDecimal.remove("STD_PKG_HI");
			return;
		}
		paramsBigDecimal.put("STD_PKG_HI",value);
	}


	public void setSTD_PKG_WGT(BigDecimal value){
		if(value==null) {
			paramsBigDecimal.remove("STD_PKG_WGT");
			return;
		}
		paramsBigDecimal.put("STD_PKG_WGT",value);
	}


	public void setSTD_UP(BigDecimal value){
		if(value==null) {
			paramsBigDecimal.remove("STD_UP");
			return;
		}
		paramsBigDecimal.put("STD_UP",value);
	}


	public void setOTHERS_FREE(String value){
		if(value==null) {
			paramsFree.remove("OTHERS");
			return;
		}
		paramsFree.put("OTHERS",value);
	}


}
